Please see the excel sheet attached. Question is on top of first page.

inancial Statement wlth Spreadsheet Worksheet Enter formulas in the below cells. Columns A through E contain a worksheet The data is in columns and rows as shown. The data is followed by a financial model. Using an electronic spreadsheet, fill in the blanks Column A Starting Data Initial investment in an asset Equipment Bank loan interest rate on the loan Starting Supplies Percent of cash paid for the supplies Income tax rate Column BColumn CColumn D Column E Row 12 1000013 6500 2500015 7.0% 16 2800 17 20% 18 19 20 21 18 25% 20 First year financial data Likely revenues Revenues uncollected at end of year Vessel expenses Shoreside expenses Cash not yet paid for expenses Ending inventory of supplies Equipment purchased during year Money owed to suppliers at year end Tax rate Principal to be repaid on loan during year 28000 23 24 25 26 27 28 29 30 31 32 7000 23 16800 24 25 8600 254026 4000 500 5550 20% 200 27 28 29 30 32 X Gb699_Fin1_Wrk.xlsx Principal to be repaid on loan during year. 32 35 36 37 38 39 40 41 42 Starting cash Equity investment Purchase equipment Bank loan Purchase supplies Starting cash 34 35 36 37 38 39 40 41 42 43 Starting balance sheet. Cash inventory Fixed assets Assets 45 46 47 48 49 45 46 47 48 49 50 51 52 53 Accounts Payable Bank Loan Equity Investment Total First-year income statement Revenues Vessel expenses Shoreside expenses Operating income Interest expense Pre-taxincome Taxes 51 52 53 54 56 57 58 59 60 56 57 58 59 60 61 62 After-tax income Expected change in cash. Start Change End 62 Cash 60 61 62 63 Expected change In cash. StartChange Cash Accounts Receivable Supplies Fixed assets Total Assets Accounts Payable Bank Loan Equity Investment Retained Earnings Debt & Equity 65 67 69 70 71 72 Difference in totals 73 74 75 76 Mnus starting cash Change to cash 74 76 Changes in balance sheet 78 Start Change Cash Accounts Receivable Supplies Fixed assets Assets 79 80 81 81 83 83 85 86 87 Accounts Payable Bank Loan Equity Investment Retained Earnings Debt & Equity 86 89 20