Answer:
Explanation:
Home Value 473000
Down payment 118250
Debt 354750
Fees 3200
Total Mortgage value (Debt + Fee) 357950
Rate 3.94%
Period per anum 26
Excel formula Bi weekly payment
=PMT(3.94%/26,26 x 15,-357950,0,0) $ 1,216.27
Payment in first 10 years 1216.27 x 10 x 26 = 316,230.2
Home Value 473000
Down payment 94600
Debt 378400
Fees 5250
Total Mortgage value (Debt + Fee) 383650
Rate 4.38%
Period per annum 12
Excel formula Monthly payment
=PMT(4.375%/12,12 x 30,-383650,0,0) $ 1,915.51
Payment in first 10 years 1915.51 x 10 x 12 = $229,861.2
The attached files shows the detailed analysis.
From the attached files and the analysis, it is evident that the couple would like to choose first option with bi weekly payments to maximize their profit and interest paid as this is lesser and more preferable than the second option.