In: Finance
Calculation & Formula given below
Answer | ||||||
Down Payment= | Purchase Value - Loan Amount | |||||
Down Payment= | $250,000- $216651 | |||||
Down Payment to be made | $33,349 | |||||
Calculation | ||||||
Loan Amount | Calculated Number ( Using Goal SeeK) | $216,651 | This formula is under Excel>Data > What if Analysis | |||
Interest | 4.125% | |||||
Repaymnet Mode | Monthly | |||||
No of Years | 30 | |||||
Interest rate Converted Monthly | 4.125%/12 | 0.344% | ||||
Number of months | 30*12 | 360 | ||||
Year | EMI | Interest | Pricipal | Remianing Balance | ||
1 | $1,050 | $745 | $305 | $216,346 | ||
2 | $1,050 | $744 | $306 | $216,040 | ||
Up to 360 Months | ||||||
359 | $1,050 | $7 | $1,043 | $1,046 | ||
360 | $1,050 | $4 | $1,046 | ($0) | ||