Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Case What If Analysis The best experience about the ABC Corp. was how to come up with Useful and innovative products in the midst of

Case "What If Analysis"
The best experience about the ABC Corp. was how to come up with Useful and innovative products in the midst of economic adversity. Due to severe price competition, the revenues and profitability was badly affected. The designer of the products have immense pressure to come up something new as a useful product to be sold. Finally, they came up with an innovation to introduce remote control dish washer.
Consultation with retailers and customers, indicated that demand of this item would be excellent, provided the price was lower than the regular machine. The testing and development phases took almost
3
years and the final product passed all safety requirements.
Before being given the go ahead to go into full capacity production of the machine, the designed team had to present a detailed financial plan to the capital investment committee CIC which was chaired by the VP of Finance department, Mr
.
Abid Majeed. The proposal had to include detailed cost and revenue estimates with ample documentation to support the numbers,
Having a vast experience of these kinds of proposals before, the head of designed team, Sarfraz Ahmed knew that he had better take every possible factor into account and be prepared for a rigorous questions in front of committee members. Fortunately for Sarfraz, his assistant Umar who had recently earned his CFA designation, was an experienced and dependable employee. Both were very keen to come up with the best recommendations supported by the financial plan.
So the Sarfraz and Abid Majeed began collecting the necessary information. They knew that to have a comprehensive feasibility study they would have to include the following:
1
.
Pro forma statements showing expected annual revenues, variable costs, and net cash flows over the economic life of the project with appropriate supporting documents;
2
.
Break Even Analysis;
3
.
Sensitivity of the cash flows to alternative scenarios of sales growth and profit margins:
Based on the data provided by the marketing department, they prepared Table
1
,
showing the expected unit sales of the machine over its
1
0
years economic life and the expected selling price per unit. Note that the price of Rs
.
1
0
0
0
per unit was estimated to gradually drop to Rs
.
9
0
0
per unit over the
1
0
-
year period reflecting competitive pressures. Depreciation for this project was based on the
7
-
year MACRS rates as shown in Table
2
.
The cost of equipment, including shipping, handling, and installation was estimated at
2
0
million. It was estimated that after
1
0
years, the equipment and tools could be sold for
4
million.
The production would be done in an unused plant of the firm. Similar plant locations could be leased for
Rs
.
1
0
,
0
0
0
per month. Fixed costs were estimated to be Rs
.
1
,
5
0
0
,
0
0
0
per year while variable production
costs per unit were expected to be Rs
.
4
0
0
.
To get the project underway, additional inventory of
5
0
0
,
0
0
0
would be required. The company would increase its accounts payable by
6
0
0
,
0
0
0
and its accounts
receivable by
1
,
0
0
0
,
0
0
0
.
Sarfraz and Abid estimated that each year thereafter, the net working capital of
the firm would amount to
5
%
of sales. The weighted average cost of capital was calculated to be
1
4
%
,
Table
1
Projected Unit Sales and Price
Unit Sales
Year
2
Unit Price
$
1
0
0
0
1
0
0
0
1
0
0
0
9
5
0
3
4
5
3
0
,
0
0
0
3
4
,
0
0
0
3
8
,
8
0
0
3
8
,
0
0
0
3
6
.
9
0
0
1
of
3
3
0
,
0
0
0
3
5
,
5
0
0
3
5
,
0
0
0
3
4
,
5
0
0
9
5
0
6
9
5
0
9
5
0
7
8
9
0
0
9
9
0
0
Table
2
Modified ACRS Depreciation Allowances
3
-
Year
3
3
.
3
3
%
Year
1
2
3
4
5
6
7
8
5
-
Year
2
0
.
0
0
%
7
-
Year
1
4
.
2
9
%
4
4
.
4
4
3
2
.
0
0
2
4
.
4
9
1
4
.
8
2
7
.
4
1
1
9
.
2
0
1
7
.
4
9
1
1
.
5
2
1
2
.
4
9
1
1
.
5
2
5
.
7
6
8
.
9
3
8
.
9
3
8
.
9
3
4
.
4
5
Questions:
1
.
Need to prepare pro forma Income statement with the help of given cash flows.
2
.
Conduct Scenario analysis by
1
5
%
plus and minus change.
3
.
Suitable calculations to realize the vulnerability of different variables in sensitivity analysis.
4
.
How should the annual interest expenses of Rs
.
4
0
0
,
0
0
0
be treated? Explain
5
.
Using the base case estimates calculate the cash, accounting, and financial breakeven.
6
.
If the company has spent
5
0
0
,
0
0
0
in developing the prototype of the machine. How both of them treat this item in their report.
7
.
Calculate the IRR of this project

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

Public Finance A Contemporary Application Of Theory To Policy

Authors: David N Hyman

12th Edition

0357442156, 978-0357442159

More Books

Students also viewed these Finance questions

Question

b. Did you suppress any of your anger? Explain.

Answered: 1 week ago