message me if you can help

Book1.xlsx

Financial statement

Thediamondprincesscollection
Income Statement
For the years of 2018-2020
		2018	2019	2020
Revenue:
Cost of goods sold		0	25	30
Gross profit		0	1000	1500
Depreciation		0	10	15
Earning before		0	1400	2000
Interest & taxes
Earning before taxes		0	1300	1800
Taxes 34%		0	30.9	50.5
Net income (Profit)		0	70	80.6
	Thediamondprincesscollection
		Balance Sheet
		May 3,2020
Assests				Liabilities
Cash	$900			Account payable		$700
Inventory	500			Bank loan		$1,000
Accounts receivable		165		Notes payable		$230
Long term assesests	assets	100		Long term debt		$500
Total current assets		$1,665		Total liablities		$2,430
Equipment		$1,000
				Owners Equity
Total assets		$4,330		A. Fort Capital		$1,900
				Total liablities & Owner’s Equity			4330
Simplest cash flow statement							Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Assumes all sales are cash sales					Opening balance		2000	2350	2550	2770	2880	2990	3000	3100	3200	3300	3400
Provision of a service					Sales revenue		1000	1500	2025	2576.25	2155.06	2762.82	3400.96	4071	4774.55	5513.28	6288.95	7103.39
Sales % increase per month				5	Total inflows		1000	1500	2025	2576.25	2155.06	2762.82	3400.96	4071	4774.55	5513.28	6288.95	7103.39
Sales in December of previous year				1000	Expenses
Bank balance on December 31st previous year				$2,000	Rent		0	0	0	0	0	0	0	0	0	0	0	0
Office expenses increase per month				4	Office expenses		100	100	100	100	100	100	100	100	100	100	100	100
					Wages		800	800	800	800	800	800	800	800	800	800	800	800
					Total outflows		900	936.4	999	1179	1366	1561	1763	1974	2193	2420	2657	3000
					Closing balance		3100	3350	3450	3550	3660	3770	3880	3990	4000	4100	4200	4300