Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi! I need help with the following question. Thanks! Your manager has asked you to evaluate launching a new product line for your company. Based

Hi! I need help with the following question. Thanks!

Your manager has asked you to evaluate launching a new product line for your company. Based on your experience and knowledge of the market, you have estimated the following results for the first five (5) years of the Project.

Expected revenues:

Year (000s)

1

2

3

4

5

$80.00

$120.00

$200.00

$320.00

$480.00

The Company yearly purchases (COGS) from suppliers = 50% of the forecasted sales.

General and administrative expenses (wages, taxes, office etc.) are estimated at 15% of sales.

Sales salaries and commissions are estimated to be 10% of sales.

The Project requires and initial equipment investment of $150.

Annual depreciation expense of the equipment is $30.

Annual interest expense on the money borrowed to pay for the equipment is $6.

The company tax rate is 35%.

Question #1 (10 marks)

Using the above projections and the template in Appendix A build a Pro-forma Income Statement for each year of the Project.

In the template below the Income Statement calculate the Operating Cash Flows and Total Cash Flows for each year.

Question #2 (10 marks)

Using your initial investment and Total Cash Flows from Question #1 calculate the following for the Project.

Net Present Value

Payback (Breakeven)

Discounted Payback (Breakeven)

Internal Rate of Return

Profitability Index

Note: The company can borrow at 5% for the initial purchase of the equipment.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Certified Lease And Finance Professionals Handbook

Authors: Deborah Reuben, Certified Lease & Finance Professionals, Equipment Finance Industry Experts

6th Edition

171743388X, 978-1717433886

More Books

Students also viewed these Finance questions

Question

What fees are not allowable in real estate in victoria

Answered: 1 week ago

Question

6. Identify seven types of hidden histories.

Answered: 1 week ago

Question

What is the relationship between humans and nature?

Answered: 1 week ago