Create spreadsheet model with time line

Assignment Help Financial Management

Reference no: EM131837400

You would like to take out a $200,000 loan to start a business. The bank is offering you a 5-year loan at 5.2% annual interest with quarterly payments. Note: The interest rates given here and in part 3 are annual values. Use the EAR convention for rate conversion.

1) Create a spreadsheet model with time line to calculate your payment and interest paid in each quarter.

2) Create spreadsheet models similar to the above model to explore the effect of loan amortization periods of 4, 5, and 6 years on the payment and interest paid in each quarter.

3) Cash flow will be tight when your business first gets started. Create a spreadsheet model and use Goal Seek with a 5.8% loan with quarterly payments to find out the number of quarters you should get for the loan to keep the payment no more than $10,000 (set up your goal as $4,000, $7,000 and $9,000). Round the quarter number up to the closest integer. What will be the quarterly payment for this loan?

Reference no: EM131837400

Questions Cloud

Risks and benefits to each offer-make final recommendation : Determine the risks and benefits to each offer and make a final recommendation to Dr. Goodman.

About the retirement plan : Mary wants to save $12,000 per year for 35 years for her retirement. How much will she have at the end of 35 years if she earns 19%

What is the par value of the common stock : A firm has $3,000,000 in its common stock account and $30,000,000 in its paid-in capital account. What is the par value of the common stock?

What is the market value of mmcs common stock : Investors require a 12 percent rate of return to purchase MMC's common stock. What is the market value of MMC's common stock?

Create spreadsheet model with time line : Create a spreadsheet model with time line to calculate your payment and interest paid in each quarter.

What is your net dollar sales projection for year : Cyber Security Systems had sales of 3,300 units at $55 per unit last year. What is your net dollar sales projection for this year?

What is present value : What is the present value of $2,725 per year, If the first payment is received 8 years from now and the last payment is received 21 years from now?

Compute incremental net income of investment for each year : The Dante Manufacturing Company is considering a new investment. Compute the incremental net income of the investment for each year.

What will be the change in price per share : What will be the change in price per share, assuming the stock was in equilibrium before the changes?

User Account

All Pages