Owner 0 2000 2000 2000 2000 2000 2000 2000 2000 2000

  • No School
  • AA 1
  • 29

This preview shows page 27 - 29 out of 29 pages.

Owner 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 Part Time 1 0% $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 Part Time 2 0% $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 Part Time 3 0% $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 Part Time 4 0% $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 Part Time 5 0% $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 Part Time 6 0% $0 $0 $0 $0 $0 $0 $660 $660 $660 $660 $660 $660 Technician 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,650 $1,815 $1,997 $2,196 $2,416 $2,657 Manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,000 $2,000 Total People 7 7 7 7 7 7 8 8 8 8 9 9 Total Payroll $6,800 $6,800 $6,800 $6,800 $6,800 $6,800 $7,610 $7,775 $7,957 $8,156 $10,376 $10,617 General Assumptions Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Plan Month 1 2 3 4 5 6 7 8 9 10 11 12 Current Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% Other 0 0 0 0 0 0 0 0 0 0 0 0 Pro Forma Profit and Loss Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sales $7,600 $10,730 $12,425 $20,812 $21,611 $22,454 $23,277 $24,135 $25,023 $25,959 $26,920 $27,922 Direct Cost of Sales $1,900 $2,683 $3,106 $5,203 $5,403 $5,614 $5,819 $6,034 $6,256 $6,490 $6,730 $6,980 Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Cost of Sales $1,900 $2,683 $3,106 $5,203 $5,403 $5,614 $5,819 $6,034 $6,256 $6,490 $6,730 $6,980 Gross Margin $5,700 $8,048 $9,319 $15,609 $16,208 $16,841 $17,458 $18,101 $18,767 $19,469 $20,190 $20,941 Gross Margin % 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% Expenses Payroll $6,800 $6,800 $6,800 $6,800 $6,800 $6,800 $7,610 $7,775 $7,957 $8,156 $10,376 $10,617 Marketing/Promotion $4,000 $4,000 $3,250 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 Utilities $760 $760 $760 $760 $760 $760 $760 $760 $760 $760 $760 $760 Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Operating Expenses $14,060 $14,060 $13,310 $12,560 $12,560 $12,560 $13,370 $13,535 $13,717 $13,916 $16,136 $16,377 27
Image of page 27
Profit Before Interest and Taxes ($8,360) ($6,013) ($3,991) $3,049 $3,648 $4,281 $4,088 $4,566 $5,050 $5,553 $4,054 $4,564 EBITDA ($8,360) ($6,013) ($3,991) $3,049 $3,648 $4,281 $4,088 $4,566 $5,050 $5,553 $4,054 $4,564 Interest Expense $250 $239 $227 $215 $204 $205 $194 $182 $170 $159 $147 $133 Taxes Incurred ($2,583) ($1,875) ($1,265) $850 $1,033 $1,223 $1,168 $1,315 $1,464 $1,618 $1,172 $1,329 Net Profit ($6,027) ($4,376) ($2,953) $1,984 $2,411 $2,853 $2,726 $3,069 $3,416 $3,776 $2,735 $3,102 Net Profit/Sales -79.31% -40.78% -23.76% 9.53% 11.16% 12.70% 11.71% 12.72% 13.65% 14.55% 10.16% 11.11% Pro Forma Cash Flow Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cash Received Cash from Operations Cash Sales $7,600 $10,730 $12,425 $20,812 $21,611 $22,454 $23,277 $24,135 $25,023 $25,959 $26,920 $27,922 Subtotal Cash from Operations $7,600 $10,730 $12,425 $20,812 $21,611 $22,454 $23,277 $24,135 $25,023 $25,959 $26,920 $27,922 Additional Cash Received Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 New Current Borrowing $0 $0 $0 $0 $0 $2,000 $0 $0 $0 $0 $0 $0 New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Subtotal Cash Received $7,600 $10,730 $12,425 $20,812 $21,611 $24,454 $23,277 $24,135 $25,023 $25,959 $26,920 $27,922 Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Expenditures from Operations Cash Spending $6,800 $6,800 $6,800 $6,800 $6,800 $6,800 $7,610 $7,775 $7,957 $8,156 $10,376 $10,617 Bill Payments $224 $6,806 $9,085 $9,172 $14,074 $12,613 $13,017 $13,159 $13,518 $13,885 $14,254 $14,063 Subtotal Spent on Operations $7,024 $13,606 $15,885 $15,972 $20,874 $19,413 $20,627 $20,934 $21,475 $22,041 $24,630 $24,680 Additional Cash Spent Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Principal Repayment of Current Borrowing $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $1,040 Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Long-term Liabilities Principal Repayment $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 28
Image of page 28
Subtotal Cash Spent $8,574 $15,156 $17,435 $17,522 $22,424 $20,963 $22,177 $22,484 $23,025 $23,591 $26,180 $26,520 Net Cash Flow ($974) ($4,426) ($5,010) $3,290 ($813) $3,491 $1,100 $1,651 $1,998 $2,368 $740 $1,402 Cash Balance $23,026 $18,600 $13,589 $16,879 $16,066 $19,557 $20,657 $22,308 $24,307 $26,675 $27,415 $28,817 Pro Forma Balance Sheet Jan Feb Mar Apr May Jun Jul Aug Sep
Image of page 29

You've reached the end of your free preview.

Want to read all 29 pages?

  • Fall '19
  • Logictech cybercafe

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 You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes