Please use excel file to work out the three examples in the exercise example slide and upload your excel file here. Please use all the cell reference and functions to do all the calculations inside the excel.

Last year $($year $1)$ balance sheet of Speith's Goll Shop, Inc. showed long$-$term debt of $$5$ million, and this year $($year $2)$ balance sheet showed long$-$term debt of $$5\mathrm{.}25$ million. This year Income statement showed an interest expense of $$165,000.$ Last year $($fear $1)$ balance sheet showed $$510,000$ in the common stock account and $$4\mathrm{.}6$million in the additional paid$-$in surplus account. This year $($year $2)$ balance sheet showed $$550,000$ and $$4\mathrm{.}8$ million in the same two accounts, respectively. The company paid out $$410,000$ in cash dividends during the year. Suppose you also know that the firm's net capital spending for this year was $$1\mathrm{.}370,000,$ and that the firm reduced its net working capital investment by $$69,000.$

What was the frrm$\text{'}$s operating cash flow for this year, or OCF?

Prepare a balance sheet for Alaskan salmon corp. for year XO $,$ based on the following Information: Cash$-$ $$197,000$; patents and copyrights $-$$$863,000$ : accounts payable $$288,000$; accounts recelvable $-$$$265,000$; tangible net fixed assets $-$$$5,150,000$; inventory $-$ $$563,000$; notes payable $-$ $$194,000$; accumulated retained earnings $-$ $$4\mathrm{.}586,000$; longterm debt $=$$$1\mathrm{.}590,000.$

Given the following information for Soolie Co$,$ calculate the depreciation expense: sales $$67000$ : costs $=$$$49200$; addition to retained earnings $=$$$3500$ : dividends paid $=$$$2170$; interest expense $-$ $$1980,$ tax rate $=40\%.$