Calculate the net present value of the commuter service

Assignment Help Financial Management

Reference no: EM131551164

Capital Budgeting Problem

Caitlin is an accounting major at Boise State University. Caitlin has realized that there are numerous students attending BSU that live in communities within 120 miles of BSU who would like to go home on weekends but don’t have cars. Caitlin, an entrepreneur at heart, believes a weekend commuting service could be organized and run profitably. She has gathered the following information:

A. Six used vans can be purchased for a total of $90,000. Each van has a four-year useful life with a salvage value of $1,500 at the end of the fourth year. Caitlin plans on using straight-line depreciation.

B. Caitlin would hire 10 drivers. Payroll expense is estimated at $48,000 annually.

C. Other annual operating expenses associated with running the commuter van service include:

Gasoline: $ 16,000

Maintenance: $ 3,300

Repairs: $ 4,000

Insurance: $ 5,000

Advertising: $ 1,200

D. Caitlin has talked to local banks and has been able to negotiate an operating loan at 14%. Use this rate for your cost of capital (the discount rate).

E. After surveying students on campus Caitlin has determined each van would make 10 round trips weekly and carry an average of five students on each trip. The vans would operate 30 weeks each year. Each student would pay $12 per round-trip ticket.

Required: Compete the following in Excel. Do your own work! If any solutions even appear to be the same, zero points will be earned for this assignment.

1) Calculate annual net income. Remember the formula for straight-line depreciation is (cost – salvage value)/useful life.

2) Calculate net annual cash flows for the service.

3) Calculate the net present value of the commuter service.

4) Based on the net present value of the service and the potential income, should Caitlin start this service?

5) What if she could not get financing for less than 20%? Should she still make the investment?

Reference no: EM131551164

Questions Cloud

About as risky as the firm existing assets : These two projects are equally risky and about as risky as the firm's existing assets. What is its cost of common equity?

Compare two companies with different fiscal years : how would you compare two companies with different fiscal years?

Define the term cost of capital : Define the term, “cost of capital” as it relates to multinational corporations.

Describe an options market hedge : Describe an “Options Market Hedge”;

Calculate the net present value of the commuter service : Calculate net annual cash flows for the service. Calculate the net present value of the commuter service.

The total transaction value when buying and selling : Brokerage commissions are 4% of the total transaction value when buying and selling.

What is amount of the company accounts receivable : What is the amount of the company’s accounts receivable?

Create artwork for general main office building : General Equity Corporation (General) entered into a contract with renowned artist Halla, who agreed to create artwork for General’s main office building.

Coupon payments are made semiannually : Coupon payments are made semiannually. What is the market price if the required annual market rate is 10%?

User Account

All Pages