Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

One year Two years Three years Four years Berry Bang's sold 1750 91000 93730 96542 99438 Revenue $7.00 637,000 656110 675793 696067 Cost of Sales

One year

Two years

Three years

Four years

Berry Bang's sold

1750

91000

93730

96542

99438

Revenue

$7.00

637,000

656110

675793

696067

Cost of Sales

$1.87

170,170

175275

180533

185949

Royalty

8.00%

50,960

52489

54063

55685

Marketing

7.00%

44,590

45928

47306

48725

Total Variable Costs

265,720

273,692

281902

290359

Contribution

371,280

382,418

393891

405708

Full-Time Employee Costs

$42,000

84,000

84,000

84,000

84,000

Casual Employee Costs

$18.93

70,874

70,874

70,874

70,874

On-Costs

30%

46,462

46,462

46,462

46,462

Total Employee Costs

201,336

201,336

201,336

201,336

Store Costs (outgoings)

$1,600

19,200

19,200

19,200

19,200

Occupancy Cost (rent)

$3,500

42,000

42,000

42,000

42,000

Total Operating Costs

262,536

262,536

262,536

262,536

EBITDA

17%

108,744

119,882

131,355

143,172

Interest

150,000

6.00%

9,000

9,000

9,000

9,000

Depreciation

300,000

10.00%

30,000

30,000

30,000

30,000

Total Fixed Costs

301,536

301,536

301,536

301,536

Pre-Tax Profit

69,744

80,882

92,355

104,172

Tax

30%

20,923

24265

27706

31252

Net Income

48,821

56,618

64,648

72,920

1- Repeat these calculations in order to estimate free cash flow for three more years, assuming that the franchise is able to increase the number of Berry Bangs it sells by 3% over the previous year. Is EBITDA equal to 33% of the $300,000 required to set up the store in each year? Note: as a rule of thumb an EBITDA/Store Setup Cost ratio of 33% is desirable.

the above is the question 1 and its answer is in table form and I need you to check the calculations and let me know that all are correct and if any calculation is wrong just let me know

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Gapenskis Cases In Healthcare Finance

Authors: George H. Pink

6th Edition

1567939651, 978-1567939651

More Books

Students also viewed these Finance questions

Question

Explain the difference between a PIM and a PSM.

Answered: 1 week ago