Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the attached spreadsheet, calculate the estimated sales for years 2021 through 2024 if your first-year sales are expected to be $100,000, and you estimate

Using the attached spreadsheet, calculate the estimated sales for years 2021 through 2024 if your first-year sales are expected to be $100,000, and you estimate sales growth rates to be 15%, 7%, and 5% and determine the probability of each occurrence to be 25% Optimistic, 50% Most likely, and 25% pessimistic.

image text in transcribed

Income Statement \begin{tabular}{lrrrr} & & \multicolumn{2}{c}{ Percent } & \multicolumn{1}{l}{ Estimate } \\ Sales & $ & 5,000.00 & 134% & $6,700.00 \\ COGS & $ & 3,750.00 & 75% & $5,025.00 \\ \cline { 2 - 5 } Gross profit & $ & 1,250.00 & $1,675.00 \\ Operating Expenses & $ & 750.00 & 15% & $1,005.00 \\ \cline { 2 - 5 } Net Income & $ & 500.00 & & $670.00 \end{tabular} $$$$$6,700.005,025.001,675.001,005.00670.00 Cash Flow Statement \begin{tabular}{lrr} Net Income & $ & 670.00 \\ Dep & $ & 62.00 \\ Accounts Receivable & $ & (20.00) \\ Increase Inventories & $ & (100.00) \\ Accounts Payable & $ & 30.00 \\ Net Cash & $ & 642.00 \end{tabular}

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

Cost Accounting Fundamentals Essential Concepts And Examples

Authors: Steven M. Bragg

6th Edition

1642210234, 9781642210231

More Books

Students also viewed these Accounting questions

Question

Aware of differences in the role of employees unions.

Answered: 1 week ago