Using the pro forma sheet provided with information from years $2013$ and $2014$ fill in the data for $2015,2016$ and $2017$ for $4$ different scenarios based on the given information in the pictures. At the end there should be $4$ copies of the pro forma with the years $2015,2016$ and $2017$ filled in $(1$ for each scenario$).$ These assumptions would allow B$\backslash$&B to prepare four financial modeling scenarios: $1.$ Additional Rental Space with $\backslash (15\backslash \%\backslash )$ Revenue Growth $2.$ Additional Rental Space with No Growth in Unit Demand $3.$ Purchase Building with $\backslash (15\backslash \%\backslash )$ Revenue Growth $4.$ Purchase Building with No Growth in Unit Demand $1.$ Additional Rental Space $-$ Rent an additional $4,000$ square foot facility. This would add $\backslash (\backslash$$ $30,000\backslash )$ of annual rent cost to the existing annual rent cost of $\backslash$$$45,000.2.$ Building Purchase $-$ Borrow $\backslash (\backslash$$ $990,000\backslash )$ for the building for $20$ years at a $\backslash (5\backslash \%\backslash )$ all fee included interest rate. Greenwood as a woman entrepreneur could apply for an SBA $504$ loan at a fixed rate of $\backslash (5\backslash \%\backslash )$ with a $\backslash (90\backslash \%\backslash )$ loan to value ratio. This loan would require personal guarantees on the entire $\backslash (\backslash$$ $990,000\backslash )$ amount for both Greenwood and Thomas. The difference between the building cost and loan amount would be paid from operating cash in $2015.$ For financial modeling purposes, the annualized total loan payments $($principal and interest$)$ would be $\backslash (\backslash$$ $79,440\backslash ).$ Interest and principal payments would be as follows: Through $2014,$ B$\backslash$&B financed all business growth from operating cash flow with very small and limited periods of debt financing. Both Greenwood and Thomas were more willing to take out a loan rather than find an investor. This was mainly due to concerns about an investor influencing the direction, values and mission of $\backslash (\backslash$mathrm$\{$B$\}\backslash$& $\backslash$mathrm$\{$~B$\}\backslash ).$ To analyze its two options and to prepare the required lender documents, B$\backslash$&B needed pro forma financial statements for the next three years $\backslash ((2015,2016\backslash ),$ and $2017).$ Refer to Exhibit $3$ for $2013$ and $2014$ Balance Sheets, and $2014$ Income Statements and Cash Flow Statements. The Balance Sheet, Income Statement and Cash Flow pro forma financial modeling templates can be found in Exhibit $4.$ Other assumptions used to enable building of pro forma financial statements were: $-$ Revenue $-$ The base scenario was revenue growth of $\backslash (15\backslash \%\backslash )$ for the next three years. Both unit demand and average price were used to calculate the $\backslash (15\backslash \%\backslash )$ growth. A second scenario of no growth in unit demand was also needed for internal use and comparison purposes. $-$ Cost of Goods Sold as a percent of sales: $20\backslash \%$ of sales in $2015$ and $\backslash (21\backslash \%\backslash )$ in $2016$ and $2017.-$ Selling expense as a percent of sales: $\backslash (25\backslash \%\backslash )$ in $\backslash (2015,26\backslash \%\backslash )$ in $2016,$ and $\backslash (27\backslash \%\backslash )$ in $2017.-$ General and Administrative Expenses: $-$ Variable expenses as percent of sales: $\backslash (5\backslash \%\backslash )$ for all three years $-$ Fixed expenses in both the rent and buy options increasing $\backslash$$$50,000$ each year due to additional employee related costs year due to additional employee related costs $-$ Depreciation: $*$The building would be depreciated over $30$ years on a straight line basis. $-$ Corporate Taxes were not applicable due to LLC status $-$ Ending receivables balance as a percent of sales: $\backslash (2\backslash \%\backslash )$ for each year $-$ Ending Inventory balance as a percent sales: $\backslash (8\backslash \%\backslash )$ for each year $-$ Ending accounts payable as a percent of sales: $\backslash (4\backslash \%\backslash )$ for each year $-\backslash (\backslash$$ $100,000\backslash )$ PP$\backslash$&E investment at the beginning of $2016$ to finance the new equipment. This would be depreciated over $10$ years at $\backslash (\backslash$$ $10,000\backslash )$ per year $-$ Payback of the Bank Loan in Current Liabilities at the beginning of $2015-$ Owner Draws $($dividends$)$ of $\backslash (\backslash$$ $175,000\backslash )$ each year if after the draw the ending cash balance will remain over $\backslash (\backslash$$ $50,000\backslash )$