1. make a 5year cash flow statement

2. complete the balance sheet

A B 1 Pre-operating Year 1/1/2020 2020 31-Dec D 2021 31-Dec E 2022 31-Dec F 2023 31-Dec G 2024 31-Dec 2 3 4 ASSET 5 Current Assets 6 Cash ? ? 2 2 884,150 884,150 ? ? 7 Total Current Asset ? ? ? ? 8 9 11 12 Non-Current Assets 10 Building (Net) Furniture and Fixtures (Net) Office Equipment (Net) Store Equipment (Net) Delivery (Vehicle) 15 Total Non-Current Assets 16 Total Asset 13 243,900 4,950 45,000 750,000 72,000 1,115,850 2,000,000 219,510 4,125 36,457 656,250 64,800 981,142 ? 195,120 3,300 27,914 562,500 57,600 846,434 ? 170,730 2,475 19,371 468,750 50.400 711,726 ? 146,340 1,650 10.829 375,000 43,200 577,019 ? 121,950 825 15,036 281,250 36,000 455,061 ? 14 17 2,000,000 1,617,941 1,241,622 841,097 414,809 18 LIABILITIES AND PARTNER'S CAPITAL 19 Long Term Debt 20 21 Equity 22 Retained Earnings 23 Total Liabilities and Partner's Capital ? ? 1,310,712 ? ? ? ? ? ? ? ? ? ? ? ? 2,000,000 24 25 2,304,000 2,534,400 2,764,800 2,995,200 3,225,600 26 REVENUE ( NET) 27 28 Less: OPERATING EXPENSES 29 Depreciation Expense 30 Utilities Expense 31 Rent Expense 32 Internet Connection Expense 33 Salaries Expense 34 Retainer's Expense 35 SSS Contribution 36 Philhealth Contribution 37 HDF Contribution 38 Repairs and Maintenance 39 Permits and Licenses 40 Total Operating Expenses 41 INCOME BEFORE INTERES & TAX 42 Less: INTEREST EXPENSE 134,708 134,708 134,708 134,708 138,708 14,400 14,400 14,401 15,281 15,587 120,000 120,000 120,000 120,000 120,000 156,000 156,000 156,000 156,000 156,000 461,760 461,760 461,760 461,760 461,760 6,000 6,000 6,000 6,000 6,000 34,070 34,070 34,070 34,070 34,070 5,400 5,400 5,400 5,400 5,400 9,235 9,235 9,235 9,235 9,235 10,000 10,000 10,000 10,000 10,000 5,000 5,000 5,000 5,000 5,000 956,573 956,573 956,574 957,455 961,760 1,347,427 1,577,827 1,808,226 2,037,745 2,263,840 123,622 90,463 66,257 40,495 13,075 1,223,805 1,487,364 1,741,969 1,997,251 2,250,765 36,714 44,621 52,259 59,918 67,523 1,310,712 1,533,206 1,755,967 1,977,828 2,196,317 43 44 INCOME TAX 3% 45 INCOME AFTER TAX/NET PROFIT 46 47 48 ADDITIONAL INFORMATION 49 LOAN SCHEDULE 50 51 Open Balance 52 Less: Repayment 53 Ending Balance 2,000,000 1,617,941 (382,059) (376,320) 1,617,941 1,241,622 1,241,622 (400,525) 841,097 841,097 (426,288) 414,809 414,809 (414,809) 54 interest rate 6.25% 123,622 90,463 66,257 40,495 13,075 55 56 Interest Expense 57 58 59 60