profit and Loss

July 2021 January 2022

 Provide a cash flow formula and Income statement of this question in excel with excel rule 

	Total
Income
Discounts given	-2,073.55
JRT Program	59,814.78
Other Income	3,866.73
Sales	69,090.47
Service Fees	44,121.16
Unapplied Cash Payment Income	-250.00
Total Income	A$ 174,569.59
Gross Profit	A$ 174,569.59
Other Income
Tas Grant	1,000.00
Total Other Income	A$ 1,000.00
Expenses
Advertising and marketing	454.55
Bank charges and fees	242.61
Electricity and Telephone	178.91
Insurance	141.86
Interest expense	3,399.40
Meals and entertainment	311.99
Merchant Fee	101.99
Motor vehicle expenses	2.55
Office expenses	1,368.16
Parking Expenses	20.46
Printing, stationery & supplies	634.09
Professional Fees	27.27
Rent	6,272.70
Service Outsource	4,707.31
Subscriptions	7,800.72
Superannuation	8,112.23
Telephone & internet expenses	1,273.87
Travel expenses	1,788.64
Wage expenses	81,723.93
Total Expenses	A$ 118,563.24
Other Expenses
Employee reimbursements	1,081.82
Total Other Expenses	A$ 1,081.82
Net Earnings	A$ 55,924.53

Answer rating: 100% (QA)

here is an Excel spreadsheet with the provided income statement and cash flow formula Income Stateme... View the full answer