Ask Question
BusinessBusiness
27 March, 13:06

You want to purchase a new condominium that costs $287,500. Your plan is to pay 25 percent down in cash and finance the balance over 15 years at 3.75 percent. What will be your monthly mortgage payment including principal and interest

+2
Answers (1)
  1. 27 March, 13:28
    0
    The monthly payment is $1,568.07

    Explanation:

    The amount required to purchase the condominium is $287,500, however the amount of finance required is : $287,500 - ($287,500*25%) = $215,625.00

    The monthly mortgage payment required can be computed using the pmt formula in excel"

    =pmt (rate, nper,-pv, fv)

    rate is the payable on the mortgage on monthly basis which is 3.75%/12=0.003125

    nper is the number of years of mortgage multiplied by 12 months since 12 monthly repayments are required in a year i. e 15*12=180

    pv is the actual mortgage value is $215,625

    fv is the future value of the mortgage and it is unknown

    =pmt (0.003125,180,-215625,0)

    pmt=$1,568.07
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “You want to purchase a new condominium that costs $287,500. Your plan is to pay 25 percent down in cash and finance the balance over 15 ...” in 📗 Business if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers
You Might be Interested in
Kim will only buy cars from Japanese automakers because she thinks cars made in the United States are of inferior quality. She has this belief even though she has never studied the ratings of cars made in the United States.
Answers (1)
Using technological tools to craft reports and proposals a. reduces the mechanical work involved in developing long reports and proposals. b. eliminates the need for the writer to do any work. c.
Answers (1)
Jane contracts Tom, a home developer, to build her a new house. In the contract it states that all necessary parts of the home must be complete before the contract is to be considered finished.
Answers (1)
Heart of Tennessee Telecom has these account balances at December 31, 2016 : Note payable, long-term ... $7800 Prepaid rent ... 2300 Salary payable ... 3000 Service revenue ... 29,400 Supplies ... 500 Accounts payable ... $3700 Accounts receivable ..
Answers (1)
If it is raining is it okay for a driver to operate the lift from the inside of the vehicle true or false
Answers (1)
New Questions in Business
A company has a defined benefit pension plan for its employees. On December 31, year one, the accumulated benefit obligation is $45,900, the projected benefit obligation is $68,100, and the fair value of the plan assets is $62,000.
Answers (2)
Which type of workplace culture emphasizes the development of new skills? a. achievement-based b. adaptive-based c. involvement-oriented d. consistency-oriented
Answers (2)
Jones Co. started the year with no inventory. During the year, it purchased two identical inventory items at different times. The first purchase cost $1,240 and the other, $1,570. Jones sold one of the items during the year.
Answers (1)
The culture of UPS places service to the customer among the company's highest business objectives, which is reflected in their use of information systems to enable customer tracking of their packages.
Answers (1)
Employers bond employees who handle cash receipts because fidelity bonds reduce the possibility of employing dishonest individuals and Deter dishonesty by making employees aware that insurance companies may investigate and prosecute dishonest acts.
Answers (1)
Home » Business » You want to purchase a new condominium that costs $287,500. Your plan is to pay 25 percent down in cash and finance the balance over 15 years at 3.75 percent. What will be your monthly mortgage payment including principal and interest
Sign Up Forgot Password?