Question

Fix 4 Less is a company for cellphone repair. The business offers variety of services s... Question: Fix 4 Less is a company for cellphone repair. The business offers variety of services such as refurbishing the screens, selling the parts online (amazon, eBay and bonanza), retail store for walk in customers and mobile repair services for those who don't have time to leave their homes or works. Business would like to add one more service which is selling the parts wholesale to other retail stores in the same market. After everything is settled business is planning to sell franchise nationwide. I need Balance Sheet, Cash Flows, Break-Even Analysis, Payback Period, ARR-IRR and Financial Ratios with fake numbers but it needs to be logical numbers for the business type.

Answer 1

Balance sheet
Current assets
Cash	11500
Accounts receivable	7850
		19350
Non-current assets
Plant and machinery	22750
Equipment	12850
		35600
		54950
Current liabilities
Accounts payable	5870
Outstanding expenses	3750
		9620
Non-current liabilities
Loans	18780
		18780
Equity:
Common stock	21750
Retained earnings	4800
		26550
		54950

Cash flow statement
Cash flow from operating activities
Cash received from service provided	9,800.00
Cash paid to employees and workers	(6,900.00)
	2,900.00
Less: Tax paid	1,600.00
		1,300.00
Cash flow from Investing activities
Machinery purchased	(20,750.00)
Equipment purchased	(13,080.00)
		(33,830.00)
Cash flow from financing activities
Loan taken	18,780.00
Common stock issued	21,750.00
		40,530.00
		8,000.00
Add: Opening cash		3,500.00
closing cash balance		11,500.00

Break even analysis
Sales	22500
Less: Variable cost	10800
contribution	11700
PV ratio	52
Fixed costs	4500
Breake even sales	8653.846154
Pay-back period:
Total investment	40530
Annual net cash inflow	20265
Pay-back period (In years)	2
ARR
Accounting profit	4800
Iniyial investment	40530
ARR	11.8430792
IRR
Net cash inflow after tax	8,000.00
Initial investment	40530
IRR	19.74