Use an amortization table (Use Spreadsheet application such as Excel) that determines the monthly mortgage payment based on interest rate of 35% and a principal of GHS1000,000 with a 15-year maturity and then for a 30-year maturity. Is the monthly payment for the 15-year maturity twice the amount for the 30-year maturity or less than twice the amount? Explain.

Use an amortization table (Use Spreadsheet application such as Excel) that determines the monthly mortgage payment based on interest rate of 35% and a principal of GHS1000,000 with a 15-year maturity and then for a 30-year maturity. Is the monthly payment for the 15-year maturity twice the amount for the 30-year maturity or less than twice the amount? Explain.

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.17: Amortized Loans

Problem 1ST

See similar textbooks

Similar questions

For each of the following situations involving annulties, solve for the unknown. Assume that interest is compounded annually and that all annulty amounts are received at the end of each period. (/= Interest rate, and n = number of years) Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3. 4. 5. Present Value 248, 196 442,750 650,000 175,000 Annuity Amount $ 5,000 80,000 60,000 155,040 8% 11% 10% n = 5 4 10 4
Use aspreadsheet to create amortization schedules for the following five scenarios.What happens to the total interest paid under each scenario?a. Scenario 1:Loan amount: $1 millionAnnual rate: 5 percentTerm: 360 monthsPrepayment: $0b. Scenario 2: Same as 1, except annual rate is7 percentc. Scenario 3: Same as 1, except term is 180monthsd. Scenario 4: Same as 1, except prepayment is$250 per monthe. Scenario 5: Same as 1, except loan amount is$125,000
For each of the following situations involving annuities, solve for the unknown. Assume that interest is compounded annually and that all annuity amounts are received at the end of each period. (/= interest rate, and n= number of years) Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1. PV of $1. FVA of $1. PVA of $1. EVAD of $1 and PVAD of $1) 1. $ 2 3 4. 15 Present Value Answer is complete but not entirely correct. Annuity Amount 2.200 145,000 190,000 72.523 45,787 8,784 558,865 480,945 520,000 240,000 8% 1.0% 9% 2.5% 10% n= 5 4 30 8 4
(1) What is the value at the end of Year 3 of the following cash flow stream if the quoted interest rate is 10%, compounded semiannually? (2) What is the PV of the same stream? (3) Is the stream an annuity? (4) An important rule is that you should never show a nominal rate on a time line or use it in calculations unless what condition holds? (Hint: Think of annual compounding, when INOM = EFF% = IPER.) What would be wrong with your answers to parts (1) and (2) if you used the nominal rate of 10% rather than the periodic rate, INOM/2 = 10%/2 = 5%?
What is the future value (at the end of 8 years) of an annuity that pays $700 a quarter over 8 years with the payments invested at 9.3% per annum (assume compounding matches payment periods, common assumption for such problems)? (enter your answer in the following format 123456.78) Answer: Check
Calculate the present value of the following annulties, assuming each annuity payment is made at the end of each compounding period. (FV of $1, PV of $1, FVA of $1, and PVA of S1) (Use tables, Excel, or a financial calculator. Round your answers to 2 decimal places.) \table[[, \table[[Annuity], [Payment]], \table [[ Annual], [Rate]], \table[[Interest], [Compounded]], \table [[Period], [Invested]], \table [[Present Value of], [ Annuity]]], [1., $5,000, 7.0%, Semiannually,3 years,], [2., 10, 000, 8.0%, Quarterly,2 years, ], [3., 4,000, 10.0 %, Annually,5 years,]]
Derive an equation to find the end-of-year future sum F that is equivalent to a series of n beginning-of-year payments B at interest rate i. Then use the equation to determine the future sum F equivalent to six B payments of $100 at 8% interest.
Percentages need to be entered in decimal format, for instance 3% would be entered as .03 in cell B12.) Set up an amortization schedule for a $60,000 loan to be repaid in equal installments at the end of each of the next 20 years at an interest rate of 20%. What is the annual payment? After you input the data for each scenario, click on the Graph tab (second tab on the worksheet) and look at the Principal and Interest portions of the payments throughout the years. What do you notice about the amount of Principal and Interest over the years (which amount is higher in the early years, and which amount is higher in the later years) of the loan? What do you notice about the difference in Principal and Interest in the 10% scenarios compared to 20% scenarios?
Suppose a borrower makes a $100,000 loan with annual payments at a 10 percent rate and a 10-year term. The loan is fully amortizing; however, payments are made on an annual basis to simplify the initial illustration. How the annual loan payment is calculated?
Use the Amortization Table to determine the payment required to amortize a loan of $7500 at an annual interest rate of 12% with a term of 15 years. Payments are to be made monthly.What is the amount of each payment?
What is the future value (at the end of 10 years) of an annuity that pays $700 a quarter over 10 years with the payments invested at 6.6% per annum (assume compounding matches payment periods, common assumption for such problems)? (enter your answer in the following format 123456.78) Answer:
For each of the following situations involving single amounts, solve for the unknown. Assume that Interest is compounded annually. (/- interest rate, and n-number of years) Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (EV of $1. PV of $1. EVA of $1. PVA of $1. EVAD of $1 and PVAD of $1) Present Value Future Value $ 36,018 S 72,000 S 43,718 S S 13,720 $ 4. S 51,746 S 5. 5 22,649 1234 86,000 48,000 180,000 8% 11% 9% n 9 10 11 15