Dr. Bhattacharya and Dr. Malinowski are considering purchasing a house together after spending 2 years as professors at UB. They
have identified a 4 bedroom, single family home in the Elmwood Village that will cost $473,000 to purchase. This home is also an investment as they only plan to live in the house for 10 years. After that time the couple anticipates selling the house for $680,000 (net revenue after all other expenses). As their smart engineering friend who has taken Engineering Economy, they have asked for your help in selecting the best mortgage option for their needs.
Option A: A special 15 year fixed rate mortgage, with bi-weekly payments (i.e. every 2 weeks or 26 payments per year). The loan's interest rate is 3.94% compounded monthly. Because of the short term (i.e. length) of this loan the bank will only require a 25% down payment. The couple would owe an additional $3,200 in closing costs and fees, however the lender will allow them to include the closing costs and fees in the loan finance amount (i.e. the amount borrowed).
Option B: Conventional 30-year mortgage with an interest rate of 4.375% APR with monthly payments, and if they choose this option they would need to make only a 20% down payment and would owe an additional $5250 in closing costs and fees. They will make the down payment from their savings (i.e. pay it in cash), but the closing costs and fees, can once again be included in the loan finance amount.
a. [1 points] Determine the monthly payments that they will make for each loan in the first ten years of ownership for both the financing options.
b. [2 points) Drs. Bhattacharya and Malinowski would like to choose the option that will maximize their total profit (i.e. minimize the total amount of interest they will paid over the ten years they own the home) at the time of sale. Which of the two lending options should they choose?
Option A: A special 15 year fixed rate mortgage, with bi-weekly payments (i.e. every 2 weeks or 26 payments per year). The loan's interest rate is 3.94% compounded monthly. Because of the short term (i.e. length) of this loan the bank will only require a 25% down payment. The couple would owe an additional $3,200 in closing costs and fees, however the lender will allow them to include the closing costs and fees in the loan finance amount (i.e. the amount borrowed).
Option B: Conventional 30-year mortgage with an interest rate of 4.375% APR with monthly payments, and if they choose this option they would need to make only a 20% down payment and would owe an additional $5250 in closing costs and fees. They will make the down payment from their savings (i.e. pay it in cash), but the closing costs and fees, can once again be included in the loan finance amount.
a. [1 points] Determine the monthly payments that they will make for each loan in the first ten years of ownership for both the financing options.
b. [2 points) Drs. Bhattacharya and Malinowski would like to choose the option that will maximize their total profit (i.e. minimize the total amount of interest they will paid over the ten years they own the home) at the time of sale. Which of the two lending options should they choose?
1 answer:
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.
You might be interested in
Answer:
Explanation:
Bank Reconciliation: The bank reconciliation deals with the bank statement balance and the cash statement balance. The motive is to compare these two statements so that the organization can run in the smoothly manner.
There are various transactions due to which the bank statement balance and the cash statement balance do not match. To match these statements, we adjust the transactions accordingly.
The preparation of the bank reconciliation statement on September 30 is presented in the spreadsheet. Kindly find the attachment below:
