Comfortable for your aging customer base

Assignment Help Financial Management

Reference no: EM131819287

You run a bike shop that rents touring bikes to tourists. You specialize in providing bikes that are more comfortable for your aging customer base (and these cush bikes aren’t cheap). Five years from now (at the end of the year), your whole fleet will need to be replaced – at $1500 a bike (and you’ll need 35). If you put $7,000 at the beginning of each year for the next 5 years into an account, and you will earn 5% interest on each $7,000 investment, will you be able to afford your new fleet (hint: what is the future value of your $7,000 investment? See p. 65 in Brayley & McLean for the formula)?

Your Excel file should depict the following (again, I must see the formulas when I click on the cells):

The amount that you will need in 4 years (F; which is cost of bikes x number of bikes you’ll need)

Interest rate (i)

Term (n, expressed in years)

TA (which you will find in Table B in Brayley & McLean p. 64) for each of the 4 years- note: this number will change each year as the number of years goes down!)

Present value (P; which is the amount of principal you will set aside each year)

The future value (F) of your $7,000 investment each year for 5 years.

Explanation- will you have enough? What specifically could you do to change that outcome?

Can comeone show me how to do this on an excel sheet.

Reference no: EM131819287

Questions Cloud

Manufacturing protective cases for popular new smart-phone : Your company is considering manufacturing protective cases for a popular new smart-phone.

Prepare general journal entries to record those transactions : Prepare general journal entries to record those transactions that created expenses in the above given order

Propose a solution to each internal control problem : Jade Applications has decided that one way to cut costs in the upcoming year is to fire the external auditor. The business believes that the internal auditor.

Calculate the amount of the pension adjustment : Mr. Arnett contributes $2,300 to the RPP. Calculate the amount of the Pension Adjustment that will be included on Mr. Arnett's T4 for the current year

Comfortable for your aging customer base : You run a bike shop that rents touring bikes to tourists. You specialize in providing bikes that are more comfortable for your aging customer base

How many months will it be before he pays off the card : If Simon makes the minimum monthly payment and makes no other charges, how many months will it be before he pays off the card?

What amount should be reported as a current liability : By December 31, 2017, 16 of the 40 home games had been played. What amount should be reported as a current liability at December 31, 2017

What amount will larkspur receive when it issues the bonds : The current market rate of interest for bonds of similar risk is 9%. What amount will Larkspur receive when it issues the bonds

How much cash should the petty cash fund hold : Accounting for petty cash transactions Suppose that on June 1, Fab Gyrations, a disc jockey service, creates a petty cash fund with an imprest balance of $250.

User Account

All Pages