Please solve, show work, and
give detail explanation
| Annual Interest Rate | 7.00% | ||||||
| Years | 3 | ||||||
| Payments Per Year | 1 | ||||||
| Amount | $53,000 | ||||||
| Equal Annual Pmt | Interest pmt | Part of principal repaid | Remaining principal | ||||
| Year | |||||||
| 1 | =(53000*0.07)*((1+0.07)^3)/((1+0.07)^3-1) | 20195.74 | =53000.00*7% | $3,710.00 | $16,485.74 | $36,514.26 | |
| 2 | =(36514.26*0.07)*((1+0.07)^2)/((1+0.07)^2-1) | 20195.74 | =36514.26*7% | $2,556.00 | $17,639.74 | $18,874.52 | |
| 3 | =(18874.52*0.07)*((1+0.07)^1)/((1+0.07)^1-1) | 20195.74 | =18874.52*7% | $1,321.22 | $18,874.52 | $0.00 | |
| $1,321.22 would be interest paid in year 3. | |||||||
| Formulae | |||||||
| (P X R) X [(1+R) ^N] / [(1+R) ^N-1] = Equal annual pmt | |||||||
| Total annual pmt - interest amount = principal pmt repaid | |||||||
| Beginning of year principal - annual principal pmt repaid = balance principal at end of year | |||||||
| P - Principal amount | |||||||
| R - Rate of interest | |||||||
| N - Number of years | |||||||
Please solve, show work, and give detail explanation Exam #1 Review Problems Chapters 1, 2, 3, 4, 5, and 8 11. Prepare a...
Please solve, show work, and give detail explanation
Exam #2 Review Problems Chapters 9 and 6 10. If you dispose of an asset and its book value is greater than its salvage value, then you will have to pay taxes on the difference between the book value and salvage value. a. True b. False 11. Long-term bonds have more interest rate risk than do short-term bonds. a. True b. False 12. Bondholders demand an inflation premium to compensation them for...
Please solve, show work, and give detail explanation
Exam #2 Review Problems Chapters 9 and 6 2. A firm has a new project that requires $210,600 of equipment. What is the depreciation expense in year 5 of the project is the equipment is classified as 7-year property for MACRS purposes? Year MACRS 14.29% 3 17.49% 4 12.49% 5 8.93% 24.49% 6 8.93% 7 8.93% 8 4.45% 3. A project has an operating cash flow of $33.000 per year. Initially, this...
Amortization with Equal Payments [LO3] Prepare an amortization schedule for a five-year loan of $71,500. The interest rate is 7 percent per year, and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?
Please solve, show work, and give detail explanation
11. The IRR decision rule is unreliable when comparing mutually exclusive projects. a. True b. False 12. Return on Assets (ROA) is an example of a profitability ratio. a. True b. False 13. For a given time period, the higher the interest rate, the smaller the future value. a. True b. False 14. Stockholders' Equity = Assets + Liabilities. a. True b. False 15. A disadvantage of the Average Accounting Return (AAR)...
Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per year, and the loan calls for equal annual payment How much is the annual total loan payment? How much interest is paid in the first year? How much total interest is paid over the life of the loan?
Please solve, show work, and give detail explanation
11. The IRR decision rule is unreliable when comparing mutually exclusive projects. a. True b. False 12. Return on Assets (ROA) is an example of a profitability ratio. a. True b. False 13. For a given time period, the higher the interest rate, the smaller the future value. a. True b. False 14. Stockholders' Equity = Assets + Liabilities. a. True b. False 15. A disadvantage of the Average Accounting Return (AAR)...
MUST SHOW ALL CORRECT EXCEL FORMULAS
5 X FILE HOME INSERT X Arial Amortization with equal payments - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 12 - A A % Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles fx Prepare an amortization schedule for a five-year loan of $67,500. The interest Paste B 1 U Clipboard Font C3 HE с D E G H 1 2 2 3 Prepare an amortization schedule for a...
Please solve, show work, and give detail explanation
4. A frim has bonds with 13 years to maturity, a yield-to-maturity (YTM) of 9.2 percent, and a current price of $928.81. The bonds make semi-annual payments. What is the coupon rate? 5. You purchase a bond with a coupon rate of 7.3 percent and a clean price of $945. If the next semi-annual coupon payment is due in two months, what is the dirty price?
Prepare an amortization schedule for a five-year loan of $67,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "0" wherever required.) b. How much interest is paid in the third year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c....
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...