financial-template-october-2019.xlsx - Description Daily Total population in targeted segment Our market share converted from total population Daily

financial-template-october-2019.xlsx - Description Daily...

This preview shows page 1 - 8 out of 31 pages.

Image of page 1

Subscribe to view the full document.

Image of page 2
Description No. of customers Daily - Total population in targeted segment 100,000 Our market share converted from total population 0 1,000 Monthly Prospects @26 days per month 26,000 Yearly Prospects 312,000 Scenario 1 Yearly number of transactions per customer 1 Annual total number of transaction/units to be sold 312,000 Daily - Prospects converted to our company from total population
Image of page 3

Subscribe to view the full document.

Scenario 2 3 936,000
Image of page 4
No. of Units: 312,000 Simplified P/L Year 1 TOTAL Per unit Fixed costs Salaries 100,000 0.321 Rent 50,000 0.160 Fees 40,000 0.128 Insurance 4,000 0.013 6,000 0.019 3,000 0.010 Utilities 6,000 0.019 Training 20,000 0.064 Depreciation 119,667 0.384 33,767 0.108 Misc. 0 0.000 Total Fixed Costs 382,434 1.23 Variable Costs - - Marketing 500,000 1.60 192,000 0.62 40,000 0.13 - - Total Variable Costs 732,000 2.35 TOTAL COSTS 1,114,433.67 3.57 BREAKEVEN PRICE 3.57 Internet & Phone Stationary and supplies Interest & principal Material cost per unit Labor cost per unit Hosting & Market Misc. Costs per unit
Image of page 5

Subscribe to view the full document.

Sales 3.00 312,000 Total Sales (AED) Variable Cost Material cost per unit Marketing 1.60 Labor cost per unit 0.62 Hosting & Market 0.13 Misc. Costs per unit - Total Variable cost per unit 2.35 Total Variable cost per period Contribution Per unit 0.7 Gross Margin 204,000 Fixed Costs Salaries 100,000 Rent 50,000 Fees 40,000 Insurance 4,000 Internet & Phone 6,000 Stationary and supplies 3,000 Utilities 6,000 Training 20,000 Depreciation 119,667 Interest & principal 33,767 Misc. Total Fixed Costs TOTAL COSTS Net Profit / Loss BE Sales (AED) /one unit Sales Volume ( no.of units ) per period
Image of page 6
Time Unit Start Unit Increment Month 4,000 28,000 Sales Volume Analysis -16% Units Sold per period 4,000 32,000 Sales Price Per unit 3.00 3.00 936,000 Total Sales 12,000 96,000 Fixed Costs per period 382,434 382,434 Variable Costs 9,385 75,077 Total Costs 391,818 457,511 Net Profit (Loss) -379,818 -361,511
Image of page 7

Subscribe to view the full document.

Image of page 8
  • Winter '16

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes