Build an amortization schedule for a loan

Assignment Help Financial Management

Reference no: EM131448242

Build an amortization schedule for a loan with the following terms: $220,000 borrowed for 3 years at 15% APR compounded monthly with payments every 4 months. You may attached a spreadsheet printout or complete a table manually below.

Reference no: EM131448242

Questions Cloud

Compute the future value and present value of an annuity : Compute the future value of a $100, 3-year ordinary annuity compounded at 5%? What is the future value of a 5-year ordinary annuity with annual payments of $200, evaluated at a 15 percent interest rate? What is the present value of an annuity that wi..

Computer-based order entry system : Your firm is contemplating the purchase of a new $565,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $57,000 at the end of that time.

Six payments to the insurance company : An insurance company is offering a new policy to its customers. Typically, the policy is bought by a parent or grandparent for a child at the child’s birth. The details of the policy are as follows: The purchaser (say, the parent) makes the following..

What is the after tax salvage value of the asset : An asset used in a four-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $6, 140,000 and will be sold for $1, 340,000 at the end of the project. If the tax rate is 30 percent, what is the after ta..

Build an amortization schedule for a loan : Build an amortization schedule for a loan with the following terms: $220,000 borrowed for 3 years at 15% APR compounded monthly with payments every 4 months. You may attached a spreadsheet printout or complete a table manually below.

What is stream of cash flows worth today : Suppose that starting one year from now you will receive $410 a year at the end of every year. If the discount rate is 8% what is this stream of cash flows worth today? Suppose that one year from now you will receive $540 and that at the end of every..

How many dollars will the cash management system free up : Neon Light Company of Kansas City ships lamps and lighting appliances throughout the country. Ms. Neon has determined that through the establishment of local collection centers around the country, she can speed up the collection of payments by one an..

What is the cost of common equity : Summerdahl Resorts' common stock is currently trading at $38 a share. The stock is expected to pay a dividend of $2.75 a share at the end of the year (D1 = $2.75), and the dividend is expected to grow at a constant rate of 4% a year. What is the cost..

Calculate interest rate at which you have to invest today : You expect your newly born child to attend college in 18 years. You have $12,000 to set aside (or that purpose. You also expect that the total cost of college education to be $100,000 by that time. Calculate the interest rate at which you have to inv..

User Account

All Pages