(a) What is the monthly payment?
(b) By choosing to include the closing costs in the loan, how much money was paid in interest on the closing costs over the life of the loan.
(c) What is the effective interest rate for this loan? (Hint: you must take into account the monthly compounding AND the closing costs.)
(d) Suppose closing costs were paid at closing. How does this change the overall cost of the loan? How does this change the effective interest rate?
(NOTE: EVERYTHING SHOULD BE DONE IN EXCEL. OTHERWISE NO POINTS. INCLUDE THE FUNCTION USED AS WELL. IF ITS POSSIBLE INCLUDE THE SPREADSHEET FILE AS WELL)
You are watching: Jerry bought a house for $400 000
Weekly Top 5 contributors are rewarded with monetary bonuses. All submissions are reviewed before reward is granted
. Ranking is refreshed hourly.
$25for 1st place$10for 2nd place$5for 3rd to 5th place
How leaderboard works
Homework Help 3,800,000
Start filling in the gaps now
New to nlinux.org?Sign up
Back to top
1902-365 Bloor St East, Toronto, ON M4W 3L4 · info
See more: Why Do Sn1 Reactions Prefer Polar Protic Solvents ? What Type Of Solvent Is Best For Sn1 Reactions