Excel

File

Edit

View

Insert

Format

Tools

Data

Window

Help

AutoSave

Home

Insert

Draw

Page Layout

Formulas

Data Review

View

Automate

Develop

General

Font

$$*\%$

$,$

larr$0$

${00}_0$

Number

B$25$

$f_x$ SHARES: Issued $26,000$ $$1-$par shares to the sharks for a $25\%$ ownership stake.

$\backslash$table$[[,],[2,],[3,],[4,],[5,1],[6,],[7,]]$

NOTE: You will use a combination of Proforma, Ratios, and the Percent$-$of$-$Sales methods to create your forecasted financials.

The Sharks gave you the $$1,000,000$ in funding you requested in exchange for $25\%$ ownership of your company's profits.

$7$

$2$

All the following are complete by March $31,2023$: $1)$ your shark funding has been received, $2)$ new capital investments have been purchased and set up$,$ and $3)$ additional labor has been hired and trained.

$3$

SELLING & ADMINISTRATIVE EXPENSE: Use a $3-$year average Percent$-$of$-$Sales to forecast S&A expenses. $($HINT: Find what percent S&A expense is for each of $2020,2021,$ and $2022,$ and average the $3$ results together. Use the resulting average S&A Percent$-$of$-$Sales to forecast S&A into the future.$)$

Scenario & Requirements

Assumptions

Forecasted Financials

Milestone $2$ Metrics

Accessibility: Investigate