Develop general-purpose spreadsheet to calculate balance due

Reference no: EM132158667

Question: Use the spreadsheet developed for Problem to analyze 180-month and 360-month house loan payments. Analyze a $100,000 mortgage loan at a nominal interest rate of 7.5% and submit a graph of the interest and principal paid over time. You need not submit the printout of the 360 payments because it will not fit on one page.

Problem: Develop a general-purpose spreadsheet to calculate the balance due, principal payment, and interest payment for each period of a loan. The user inputs to the spreadsheet will be the loan amount, the number of payments per year, the number of years payments are made, and the nominal interest rate. Submit printouts of your analysis of a loan in the amount of $15,000 at 8.9% nominal rate for 36 months and for 60 months of payments.

Reference no: EM132158667

Questions Cloud

What is the amount that the mayflower should report : What is the amount that The Mayflower should report as Total Current Liability on its balance sheet as of December 31, 2015

By how much will it need to increase its sales : If the company wishes to increase its total dollar contribution margin by 30% in 2017, by how much will it need to increase its sales

Define what you must deposit each year : If the interest rate is 10%, is the following statement approximately true? "Waiting 5 years to start saving double is what you must deposit each year."

What is amount of interest should capitalize : What is the amount of interest Seikely- Anderson should capitalize in 2013 assuming that the specific interest method is used

Develop general-purpose spreadsheet to calculate balance due : Develop a general-purpose spreadsheet to calculate the balance due, principal payment, and interest payment for each period of a loan.

Internet control message protocol : An attack that uses the Internet Control Message Protocol (ICMP) to flood a victim with packets.

What is the journal entry for the issuance of the note : Shea industries, a dental supplies facilitator, borrowed $480,000 cash on October 1, 2013. What is the journal entry for the issuance of the note

Should columbia pizza buy the second oven : Based on your calculations, should Columbia Pizza buy the second oven? Why? What is the net financial impact?

How long will take to recover the initial investment : A homeowner may upgrade a furnace that runs on fuel oil to a natural gas unit. The investment will be $2500 installed. The cost of the natural gas will average.

User Account

All Pages