Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume it is late in Year 1 of a three-year period, and you are trying to build a model of a company's net income (profit)

Assume it is late in Year 1 of a three-year period, and you are trying to build a model of a company's net income (profit) and cash flow for Years 2 and 3. The problem is to forecast net income and cash flow in those years. The company is likely to use the forecasts to make decisions, so the estimates should be as accurate as you can make them. After researching the problem, you decide that the estimates should be based on three factors: (1) Year 1 results, (2) estimates of the underlying economic variables, and (3) the cost of products the company sells.

Your model will use an income statement and cash flow framework. The user can enter values for two pos-sible states of the economy in Years 2 and 3: an O for an optimistic outlook or a P for a pessimistic outlook. The state of the economy is expected to affect the number of units the company can sell as well as each unit's selling price. In a good (optimistic) economy, more units can be sold at a higher price. The user can also enter values into your model to see two possible trends in the cost of goods sold: U for up or D for down. A U means that the cost of an item sold will be higher than it was in Year 1; a D means that the cost will be less.Presumably, the company will do better in a good economy and with lower input costsbut how much better? The user can play "what if" with the input variables and note the effect on net income and year-end

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

Introduction To Corporate Finance

Authors: Laurence Booth, Sean Cleary

3rd Edition

978-1118300763, 1118300769

More Books

Students also viewed these General Management questions