How much principal reduction will occur in first payment

Assignment Help Financial Accounting

Reference no: EM13866714

You are planning on buying a house for $250,000. You have an agreement with the credit union to borrow the needed money if you make a 20 percent cash down payment, and make monthly payments for 30 years at an annual interest rate of 5.25 percent compounded monthly.

a) What monthly payments will be required?

b) How much principal reduction will occur in the first payment? How much principal reduction will occur in the last payment?

c) Prepare a spreadsheet that will show each payment, how much of each payment will go to principal and how much will to interest, the current loan balance, the current equity, and the cumulative interest paid. Graph interest paid and principal paid vs. time.

Reference no: EM13866714

Questions Cloud

What meant by proactive retroactive and simultaneous update : What is meant by Proactive, Retroactive and Simultaneous Update. What are the different types of JOIN operations?

Using the cash–basis method of accounting : Discuss some of the advantages or disadvantages of using the cash–basis method of accounting. Provide some examples.

What interest expense would it recognize in income statement : Auerbach Inc. issued 4% bonds on October 1, 2013. The bonds have a maturity date of September 30,2023 and a face value of 300 million. the bonds pay interest each March 31 and September 30, beginning March 31, 2014. the effective interest rate establ..

Integrate the comprehensible input and interaction : Integrate the Comprehensible Input and Interaction

How much principal reduction will occur in first payment : You are planning on buying a house for $250,000. You have an agreement with the credit union to borrow the needed money if you make a 20 percent cash down payment, and make monthly payments for 30 years at an annual interest rate of 5.25 percent comp..

Evaluate a mode of study that you do well : Evaluate a mode of study that you do well and one that you could improve on. Please explain how you plan on improving that which you find to be weak in your own study habits

Considered for new sanitary sewer systems : Two water pumps are being considered for new sanitary sewer systems. Pump A costs $10,000 new, will cost $400 per year to operate, and has a salvage value at the end of ten years of $2,500. Pump B costs $6,500 new, costs $800 per year to operate, and..

What is cold backup and hot backup in case of oracle : What is cold backup and hot backup (in case of Oracle)? What are Armstrong rules? How do we say that they are complete and/or sound?

Operating in enhancement mode : Explain what happens inside a semiconductor device when it is operating in enhancement mode.

User Account

All Pages