Fix 4 Less is a company for cellphone repair. The business offers variety of services s......

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.

Solutions

Expert Solution

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

ekkarill92 answered 8 months ago

Next > < Previous

Related Solutions

Fix 4 Less is a company for cellphone repair. The business offers variety of services such...

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...

If a company sell a software, and it only offers the services to fix system vulnerabilities....

If a company sell a software, and it only offers the services to fix system vulnerabilities. Are there two performance obligations or one?

Tom's Shoe Repair provides a variety of shoe repair services. Analysis of monthly costs revealed the...

Tom's Shoe Repair provides a variety of shoe repair services. Analysis of monthly costs revealed the following cost formulas when direct labor hours are used as the basis of cost determination: Supplies: y=$0+$4.00X Production supervision and direct labor: y=$500+$7.00X Utilities: y=$350+$5.40X Rent: y=$450+$0.00X Advertising: y=$75+$0.00X a. Prepare a flexible budget 250, 300, 350, and 400 direct labor hours. b. Calculate a total cost per direct labor at each level of activity. c. Tom's employees usually work 350 direct labor hours...

Thunderduck Car Repair is a company that provides car repair services and is in its second...

Thunderduck Car Repair is a company that provides car repair services and is in its second year of operations. The company uses accrual basis accounting and follows GAAP. Financial statements must be provided monthly to the company’s lender, White Rock Bank, on a monthly basis. Assignment Record January transactions in the General Journal and post to the General Ledger. Record adjusting entries for January in the General Journal and post to the General Ledger. Prepare the adjusted trial balance as...

Due to less business at many car repair workshops during lockdown, some of the workshops had...

Due to less business at many car repair workshops during lockdown, some of the workshops had to lay off a number of employees. People were mostly working from home and they were not using their cars. John was among the people that were retrenched. The industry consultants reckon it could take them a while before the business can peak. John decided to set his own backyard business at home where he could serve the people in his neighbourhood. He then...

Sabrri Spa offers a variety of skin treatments and spa services, including massages, facials, body treatments,...

Sabrri Spa offers a variety of skin treatments and spa services, including massages, facials, body treatments, and manicures. The spa is owned by the largest dermatology practice in town, and the doctors invested $450,000 to start the spa five years ago. The spa is in its own building next to the clinic, and it has its own staff and management, so almost all of the spa’s costs are direct costs. The average one-hour treatment is priced at $100. Sabrri has...

Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security...

Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 2016: Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 1 Unadjusted Unadjusted Adjusted Adjusted 2 Trial Balance Trial Balance Adjustments Adjustments Trial Balance Trial Balance 3 Debit Credit Debit Credit Debit Credit 4 Cash 18.00 5 Accounts Receivable 90.00 6 Supplies 14.00 7...

Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare...

Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare the closing entries for Alert Security Services Co. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 1 Adjusted Adjusted 2 Trial Balance Trial Balance Income Statement Income Statement Balance Sheet Balance Sheet 3 Debit Credit Debit Credit Debit Credit 4 Cash 13.00 5 Accounts Receivable 108.00 6 Supplies 8.00 7 Prepaid Insurance 2.00 8 Land 184.00 9 Equipment 50.00...

Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...

Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 2019. In addition, the data for year-end adjustments are as follows: Fees earned, but not yet billed, $34. Supplies on hand, $8. Insurance premiums expired, $42. Depreciation expense, $17. Wages accrued, but not paid, $17. Enter the adjustment data, and place...

Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...

Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows: Fees earned but not yet billed, $18. Supplies on hand, $4. Insurance premiums expired, $22. Depreciation expense, $9. Wages accrued but not paid, $9. Enter the adjustment data and place...

Subjects