Determine the required down payment percentage and apr

Assignment Help Business Management

Reference no: EM13768897

Project Description

As a financial consultant, you work with people who are planning to buy a new house. You want to create a worksheet containing variable data (the price of the house, down payment, date of the first payment, and borrower's credit rating) and constants (property tax rate, years, and number of payments in one year). Borrowers pay 0.5% private mortgage insurance (PMI) of the loan amount if they do not make at least a 20% down payment. A borrower's credit rating determines the required down payment percentage and APR. For example, a person with an excellent credit rating may make only a 5% down payment with a 3.25% APR loan. A per-son with a fair credit rating will make a 15% down payment and have a higher APR at 5.25%. Your worksheet needs to perform various calculations. The filled cells in column F indicate cells containing formulas, not values.

Reference no: EM13768897

Questions Cloud

Group of private investors purchased a condominium complex : A group of private investors purchased a condominium complex for $2 million. They made an initial down payment of 10% and obtained financing for the balance. If the loan is to be amortized over 11 years at an interest rate of 8.6%/year compounded qua..

Find the periodic payment : Find the periodic payment R required to amortize a loan of P dollars over t years with interest charged at the rate of r% year compounded m times a year.

Using motivation to improve performance : Motivation is a complex subject, but its understanding and application is central to the success of management and organizational success. Imagine that you have been tasked by the CEO of your organization (current or past) with recommending action..

Present value for various compounding periods : Present Value for Various Compounding Periods-Find the present value of $700 due in the future under each of the following conditions. Round your answers to the nearest cent.

Determine the required down payment percentage and apr : A borrower's credit rating determines the required down payment percentage and APR. For example, a person with an excellent credit rating may make only a 5% down payment with a 3.25% APR loan. A per-son with a fair credit rating will make a 15% do..

What was its interest expense : Molteni Motors Inc. recently reported $3.25 million of net income. Its EBIT was $7.75 million, and its tax rate was 35%. What was its interest expense? Round your answer to the nearest dollar. Enter your answer in dollars. For example, an answer of $..

What is the net present value for this project : Phone home inc. is considering a new 4 year expansion project that requires an initial fixed asset investment of $3 million. The fixed asset will be depreciated straight-line to 0 over it's 4 year tax life, after which time it will have a market valu..

Effective implementation of strategic changes outlined : Consultant who has been employed to advise Phab on the effective implementation of strategic changes outlined in the Case Study.

Expected return-what must expected return on this stock be : A stock has a beta of 1.08, the expected return on the market is 10.2 percent, and the risk-free rate is 4.85 percent.

User Account

All Pages