Question

Lon Timur is an accounting major at a midwestern state university located approximately 60 miles from a major city. Many of the students attending the university are from the metropolitan area and visit their homes regularly on the weekends. Lon, an entrepreneur at heart, realizes that few good commuting alternatives are available for students doing weekend travel. He believes that a weekend commuting service could be organized and run profitably from several suburban and downtown shopping mall locations. Lon has gathered the following investment information. 1. Five used vans would cost a total of $76,136 to purchase and would have a 3-year useful life with negligible salvage value. Lon plans to use straight-line depreciation. 2. Ten drivers would have to be employed at a total payroll expense of $47,400. 3. Other annual out-of-pocket expenses associated with running the commuter service would include Gasoline $15,800, Maintenance $3,200, Repairs $3,700. Insurance $4,400, and Advertising $2,800. 4. Lon has visited several financial institutions to discuss funding. The best interest rate he has been able to negotiate is 15%. Use this rate for cost of capital. 5. Lon expects each van to make ten round trips weekly and carry an average of six students each trip. The service is expected to operate 30 weeks each year, and each student will be charged $12 for a round-trip ticket. Click here to view PV table. Determine the annual (1) net income and (2) net annual cash flows for the commuter service. (Round answers to 0 decimal places, e.g. 125.) Net income $ Net annual cash flows $ 100000 76136 (b) Compute (1) the cash payback period and (2) the annual rate of return. (Round answers to 2 decimal places, e.g. 10.50.) Cash payback period years Annual rate of return
pls show work! thank you

Answer 1

Solution a:

Computation of annual income - Commuter service
Particulars	Amount
Sales Revenue (5*10*30*6*$12)	$108,000
Cost:
Gasoline	$15,800
Maintenance	$3,200
Repairs	$3,700
Insurance	$4,400
Advertising	$2,800
Payroll expense	$47,400
Depreciation ($76,136/3)	$25,379
Net Annual Income	$5,321

Computation of Cash Flows - Commuter service
Particulars	Amount
Net Annual Income	$5,321
Add: Depreciation	$25,379
Annual cash flows	$30,700

Solution b:

Cash payback period = Initial investment / Annual cash inflows = $76,136 / $30,700 = 2.48 years

Annual rate of return = Average annual income / Average investment

Average investment = (Cost + Salvage value) / 2 = $76,136/2 = $38,068

Annual rate of return = $5,321 / $38,068 = 13.98%

Solution c:

Computation of NPV - Commuter service
Particulars	Amount	Period	PV Factor	Present Value
Cash Outflows:
Cost of Investment	$76,136.00	0	1	$76,136
Present Value of Cash Outflows (A)				$76,136
Cash Inflows:
Annual cash inflows	$30,700.00	1-3	2.28323	$70,095
Present Value of Cash Inflows (B)				$70,095
Net Present Value (B-A)				-$6,041