Find the amount of interest paid each month

Reference no: EM132004164

Question: Ms. Manifee would like to purchase a new condo for $105,000. She plans to make a down payment of $50,000 and to borrow the rest of the money from the bank. The bank charges an annual percentage rate of 4% compounded daily. She agrees to monthly payments to pay off the loan in 10 years.

a) Write or copy from an Excel table the amount of interest paid each month, the amount that is paid on the principal each month, and the balance remaining at the end of each month. You only need to copy the Excel table for the first 2 years of the 10-year loan. Please do not attach the Excel file as a separate file in your homework submission.

b) Assume Ms. Manifee has made 14 payments and would like to pay off the balance immediately after the 14th payment. Write down the equation or Excel formula that enables you to calculate this balance. The formula should not be recursive.

Reference no: EM132004164

Questions Cloud

Calculate the value of the tax shield : Assume the tax rate is 30% and the opportunity cost of capital is 4%. Calculate the value of the tax shield if the kiln is currently expensed.

Inequality in the united states helpful : In your view, is the extent of social inequality in the United States helpful or harmful to society as a whole? Explain.

Company has total debt and total equity ratio : The company has a total debt/total equity ratio of 50%.

Define child support : Define child support and explain the public policy behind requiring parents to pay child support.

Find the amount of interest paid each month : Write or copy from an Excel table the amount of interest paid each month, the amount that is paid on the principal each month, and the balance remaining.

Why did the companies and services described in this case : Why did the companies and services described in this case need to maintain and analyze big data? What business benefits did they obtain?

Distinguish scholarly writing from other forms : What characteristics distinguish "scholarly writing" from other forms?

Prepare a time-phased product structure : The demand for subassembly S is 100 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 1 unit of V, 2 units of W.

Calculate the book value of the equipment at december : Calculate the book value of the equipment at December 31, 2015 assuming ABC Company employs the straight line depreciation method

User Account

All Pages