$1)$Consider the following financial information about Sam's Cake Factory for Dec. $31,1999.$ The company assets are cash,

$$3,350$; notes receivable, $$1,546$; accounts receivable, $$4,675$; merchandise inventory, $$2,345$; land, $$90,125$; equipment,

$$15,560.$ The liabilities are accounts payable, $$18,575$; wages payable, $$25,432$; notes payable, $$26,821.$ The owner's cap$-$

ital is $$46,773.$

We also have the following financial information for Dec. $31,1998$: The company assets are cash, $$2,200$; notes receiv$-$

able, $$1,490$; accounts receivable, $$4,496$; merchandise inventory, $$2,857$; land, $$85,945$; equipment, $$17,651.$ The liabili$-$

ties are accounts payable, $$16,532$; wages payable, $$22,351$; notes payable, $$24,956.$ The owner's capital is $$50,700.$

$($a$)$ Create a balance sheet for each of the above.

$($b$)$ Perform a vertical analysis on each balance sheet.

$($c$)$ Perform a comparative analysis of the two balance sheets.

$($d$)$ Perform a horizontal analysis using the two balance sheets.

$2)$Consider the following information about Sam's Cake Factory for the year ending Dec. $31,1999.$ Gross sales are $$115,438,$

returns and allowances are $$1,510.$ The cost of beginning inventory is $$5,439$; the cost of purchases is $$25,436,$ and the cost

of ending inventory is $$7,631.$ Operating expenses are: rent $$18,000,$ wages $$45,036,$ insurance $$1,200,$ utilities $$13,490,$

maintenance $$1,092,$ and depreciation $$856.$

We also have the following information for the year ending Dec. $31,1998.$ Gross sales are $$110,208,$ returns and

allowances are $$1,320.$ The cost of beginning inventory is $$5,289,$ the cost purchases is $$24,458,$ and the cost of ending

inventory is $$6,409.$ Operating expenses are: rent $$16,500,$ wages $$44,876,$ insurance $$1,100,$ utilities $$11,209,$ mainte$-$

nance $$958,$ and depreciation $$776.$

$($a$)$ Create an income statement for each of the above.

$($b$)$ Perform a vertical analysis on each income statement.

$($c$)$ Perform a comparative analysis of the two income statements.

$($d$)$ Perform a horizontal analysis using the two income statements.

$3)$Consider the following information about Speedy Auto Company for the year ending Dec. $31,1997.$ Gross sales are

$$345,008,$ returns and allowances are $$35,467.$ The cost of beginning inventory is $$54,690,$ the cost of purchases is

$$155,078,$ and the cost of ending inventory is $$55,676.$ Operating expenses are: rent $$11,900,$ wages $$56,790,$ insurance

$$800,$ utilities $$2,400,$ maintenance $$879,$ and depreciation $$566.$

We also have the following information for the year ending Dec. $31,1996.$ Gross sales are $$285,865,$ returns and

allowances are $$15,467.$ The cost of beginning inventory is $$48,036,$ the cost of purchases is $$123,900,$ and the cost of end$-$

ing inventory is $$54,690.$ Operating expenses are: rent

Compose and present the financial spredsheets using Excel documents.

You will need to present full financial statement spreadsheets for each problem that demonstrates ALL of your analysis.

A separate spreadsheet analysis must be presented for each assigned problem.

All analysis is to be shown on the excel documents for each problem.

Please present full financial statement spreadsheets in excel for each of the assigned problems. Show ALL calculations, comparisons, etc. on the spreadsheets.