You want to buy a house that costs $285,000. You will make a down payment equal to 20 percent of the price of the house and fina
nce the remainder with a loan that has an APR of 5.49 percent compounded monthly. If the loan is for 30 years, what are your monthly mortgage payments
1 answer:
Answer:
$1,293.13
Explanation:
For computing the monthly mortgage payments we use the PMT formula i.e to be shown in the attachments below:
Given that,
Present value = $285,000 - $285,000 × 20% = $228,000
Future value = $0
Rate of interest = 5.49% ÷ 12 months = 0.46%
NPER = 30 years × 12 months = 360 months
The formula is shown below:
= PMT(Rate;NPER;-PV;FV;type)
The present value come in negative
After applying the above formula, the monthly mortgage payment is $1,293.13
You might be interested in
Answer and Explanation:
The computation of firm’s market value capital structure and the Weighted average cost of capital is shown with the help of spreadsheet. Kindly find it below
The formulas that we use in spreadsheet is shown below:-
WACC = Weightage of debt × cost of debt × ( 1- tax rate) + (Weightage of preferred stock) × (cost of preferred stock) + (Weightage of common stock) × (cost of common stock)
As per question, we apply the Capital Asset Pricing Model (CAPM) formula which is shown below
Expected rate of return = Risk-free rate of return + Beta × (Market rate of return - Risk-free rate of return)
The market rate of return - risk free rate of return = market risk premium
