Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Crystal Ball extension, or any Excel formulas, develop a 3-year financial analysis for the following data given: Sales volumes in the first year is

Using Crystal Ball extension, or any Excel formulas, develop a 3-year financial analysis for the following data given:

Sales volumes in the first year is estimated to be 100,000 Units and is projected to grow at a rate that is normally distributed with a mean of 7% per year and a standard deviation of 4%.

The selling price is $10 (initial-year 0), and the price increase is normally distributed with a mean of $0.5 and standard deviation of $0.05 each year.

Per unit variable costs are $3 (initial-year 0), and annual fixed costs are $200,000(initial-year 0).

Per-unit costs are expected to increase by an amount normally distributed with a mean of 5% per year and standard deviation of 2%.

Fixed costs are expected to increase following a normal distribution with a mean of 10% per year and standard deviation of 3%.

What's the average 3-year profit based off this info?

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

Effect Of Audit Quality On The Market Value Of Listed Non Financial Companies In Nigeria

Authors: Dr. Patience Ote Ola

1st Edition

6200479496, 978-6200479495

More Books

Students also viewed these Accounting questions

Question

Be sensitive to and adapt to the diversity of your audience.

Answered: 1 week ago

Question

What is Working Capital ? Explain its types.

Answered: 1 week ago

Question

design a simple performance appraisal system

Answered: 1 week ago