Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started