Which of the two is better financing decision

Assignment Help Financial Management

Reference no: EM131085561

System Admin Max Points: 5.0 You are in the process of buying a house. Your mortgage lender reviewed your credit score, employment history, debt-to-income ratio, and available funds you’ve set aside for the down payment. He quoted you a 2.75% interest rate for a 15-year loan, and a 3.50% rate for a 30-year mortgage loan. The house you want is $200,000 and you can make a 10% down payment. Using Excel, construct an amortization schedule for the amount you need to borrow from your mortgage lender for each loan option. Which of the two is a better financing decision, and why? Show all formulas required to perform these calculations and fully explain your decision making process.

Reference no: EM131085561

Questions Cloud

Example of the use of sinking fund : Which of the following is not an example of the use of a sinking fund?

Assets must grow at the same rate as projected sales : Broussard Skateboard's sales are expected to increase by 25% from $7.4 million in 2013 to $9.25 million in 2014. Its assets totaled $2 million at the end of 2013. Broussard is already at full capacity, so its assets must grow at the same rate as proj..

Find cash flow from the mark-to-market proceeds on contract : The multiplier for a futures contract on a certain stock market index is $250. The maturity of the contract is one year, the current level of the index is 1,500, and the risk-free interest rate is 0.2% per month. The dividend yield on the index is 0...

Risks asset allocation is diversified among different asset : To minimize risks asset allocation is diversified among different asset classes, the book recommended that you use an online asset allocation _______ to help you adjust your risk.

Which of the two is better financing decision : System Admin Max Points: 5.0 You are in the process of buying a house. Your mortgage lender reviewed your credit score, employment history, debt-to-income ratio, and available funds you’ve set aside for the down payment. Which of the two is a better ..

Assume the first parcel is issued at market yield : A bank agrees to establish a two year Billy facility using 90 day bank bills. the face value of the facility is $10million, and the issuer is charged an acceptance fee of 50 basis points. Determine the net cash flows, from the issuer’s perspective, o..

Calculate the value of one share of stock at the end of year : You are interested in purchasing enough number of shares in Nike so that you can be guaranteed a seat on the board of directors when the next annual shareholder’s meeting is held. Nike currently has 10,000 shares outstanding. Calculate the dividends ..

What is self-supporting growth rate : Maggie's Muffins, Inc., generated $2,000,000 in sales during 2013, and its year-end total assets were $1,400,000. Also, at year-end 2013, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..

Financing needs will be met by issuing new long-term debt : At year-end 2013, Wallace Landscaping’s total assets were $1.6 million and its accounts payable were $320,000. Sales, which in 2013 were $2.5 million, are expected to increase by 30% in 2014. Total assets and accounts payable are proportional to sale..

User Account

All Pages