Week 4 assignment

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