Calculate the total amount of interest paid throughout

Assignment Help Financial Management

Reference no: EM132027533

You are thinking of purchasing a house that costs $230,000. You have $20,000 in cash for a down payment, but you need to borrow the rest of the purchase price.

The bank is offering a 30- year mortgage that requires monthly payments and has an annual interest rate of 4.55%. What will your monthly payments be if you sign up for this mortgage?

Draw the amortization schedule on a monthly basis using Excel. Calculate the total amount of interest paid throughout the life of the loan.

Create a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan. Suppose you have the option to take out a 15-year mortgage with an annual interest rate of 3.95%.

What would the monthly payment be for this mortgage? Draw a new amortization schedule in a separate Excel sheet.

Calculate the total amount of interest paid throughout the life of the loan. How much would you save if you choose the 15-year over the 30-year mortgage?

Reference no: EM132027533

Questions Cloud

What annual interest rate will the bond earn : You are thinking about buying a savings bond. The bond costs $46 today and will mature in 15 years with a value of $92.

Thomas-nadal will purchase how much goods in quarter 3 : Assume that there are 30 days in each month. Thomas-Nadal will purchase _____ of goods in quarter 3 and pay their suppliers _____ during quarter 3.

What will be your annual payment if you sign this mortgage : The bank is offering a 30-year mortgage that requires annual payments and has an interest rate of 9% per year .

What is its times-interest-earned ratio : Thomson Trucking has $20 billion in assets, and its tax rate is 30%. Its basic earning power (BEP) ratio is 12%, and its return on assets (ROA) is 5%.

Calculate the total amount of interest paid throughout : Draw the amortization schedule on a monthly basis using Excel. Calculate the total amount of interest paid throughout the life of the loan.

Record the journal entries for the given transactions : Record the journal entries for the following transactions. On April 1st, the Batman Company received a deposit from their customer for future services

Calculate all the cash flows from the purchase : It would be subject to a 5% investment tax credit. The fogger is in the SACRS(20%, 30%, 25%, 25%) class. We would use it for 5 years and sell it for $1,600.

Calculate the annual depreciation charges : She asks you to use the following probability distribution of NPV to study the project's risk. Would you recommend the project be accepted?

Calculate the first year net earnings : The company incurred operating expenses of $17,100. Calculate the first year's net earnings under the cash basis of accounting, and accrual basis of accounting

User Account

All Pages