x3.xlsx - Financial Plan Assumptions Balance Sheet Accounts receivable Inventory Accounts payable 1 months 2 months 1 months Income Statement Ratio of

x3.xlsx - Financial Plan Assumptions Balance Sheet Accounts...

This preview shows page 1 - 4 out of 12 pages.

Financial Plan Assumptions 12/05/2019 07:46:17 Confidential 531e5d965eb928a9baad36d74d1ee7fc45289228.xlsx Assumptions Balance Sheet Accounts receivable 1 months Inventory 2 months Accounts payable 1 months Income Statement Ratio of D1 to H1 10 Revenue H1 $ 250,000 D1 $ 50,000 Cost of Goods H1 35% D1 45% Commissions 8% Payroll taxes and benefits 25.00% % of salary Recruiting cost $ 15,000 Fee Sundry costs 200 $ per head Travel per head $3,000 Venture debt interest rate 7.25% Taxes 25% rate Fixed Assets Fixed Assets/Head $5,000 Depreciation 36 months Total capital required $ (184,166) Issuance cost $75,000 Debt to equity ratio -2.88%
Image of page 1
Financial Plan Balance Sheets 12/05/2019 07:46:17 Confidential 531e5d965eb928a9baad36d74d1ee7fc45289228.xlsx B.S. Assets January February March April May June July August September October November December Cash ($403,295) ($676,930) ($942,007) ($1,237,900) ($1,569,610) ($1,866,719) ($2,258,991) ($2,867,263) ($3,400,535) ($5,121,083) ($5,207,007) ($4,839,805) Accounts Receivable 0 0 0 0 0 0 0 0 0 1,500,000 2,250,000 3,000,000 Inventories 0 0 0 0 0 0 0 0 0 1,250,000 1,875,000 2,500,000 Total Current Assets (403,295) (676,930) (942,007) (1,237,900) (1,569,610) (1,866,719) (2,258,991) (2,867,263) (3,400,535) (2,371,083) (1,082,007) 660,195 Fixed Assets 50,000 80,000 110,000 140,000 170,000 170,000 245,000 245,000 245,000 245,000 245,000 245,000 Accumulated Depreciation (1,389) (3,611) (6,667) (10,556) (15,278) (20,000) (26,806) (33,611) (40,417) (47,222) (54,028) (60,833) Deposits Total Assets ($354,684) ($600,541) ($838,673) ($1,108,455) ($1,414,887) ($1,716,719) ($2,040,797) ($2,655,874) ($3,195,952) ($2,173,306) ($891,034) $844,362 Liabilities Accounts Payable $117,700 $78,725 $79,125 $84,525 $79,925 $49,925 $340,925 $265,925 $265,925 $831,925 $1,204,425 $1,576,925 Total Current Liabilities 117,700 78,725 79,125 84,525 79,925 49,925 340,925 265,925 265,925 831,925 1,204,425 1,576,925 Venture Debt 5,304 5,304 5,304 5,304 5,304 5,304 5,142 4,979 4,815 4,650 4,484 4,317 Total Liabilities 123,004 84,029 84,429 89,829 85,229 55,229 346,067 270,904 270,740 836,575 1,208,909 1,581,242 Shareholders' Equity Series A Preferred Stock (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) Common Stock Total Equity (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) (264,470) Retained Earnings (Deficit) (213,218) (420,100) (658,632) (933,814) (1,235,646) (1,507,478) (2,122,394) (2,662,308) (3,202,222) (2,745,411) (1,835,474) (472,411) Total Shareholders' Equity (477,688) (684,570) (923,102) (1,198,284) (1,500,116) (1,771,948) (2,386,864) (2,926,778) (3,466,692) (3,009,881) (2,099,944) (736,881) Total Liabilities & Shareholders Equity ($354,684) ($600,541) ($838,673) ($1,108,455) ($1,414,887) ($1,716,719) ($2,040,797) ($2,655,874) ($3,195,952) ($2,173,306) ($891,034) $844,362
Image of page 2
Financial Plan Income Statements I.S. Confidential 531e5d965eb928a9baad36d74d1ee7fc45289228.xlsx I.S. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Revenue H1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500,000 $750,000 $1,000,000 $2,250,000 D1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,000,000 $1,500,000 $2,000,000 $4,500,000 Total Revenue $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500,000 $2,250,000 $3,000,000 $6,750,000 COGS H1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $175,000 $262,500 $350,000 $787,500 D1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $450,000 $675,000 $900,000 $2,025,000 Total Cost of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $625,000 $937,500 $1,250,000 $2,812,500 Gross Margin $0 $0 $0 $0 $0 $0 $0 $0 $0 $875,000 $1,312,500 $1,750,000 $3,937,500 Sales & Marketing $0 $0 $0 $0 $0 $0 $343,083 $268,083 $268,083 $258,083 $333,083 $408,083 $1,878,500 Engineering $81,650 $113,300 $144,950 $176,600 $208,250 $178,250 $178,250 $178,250 $178,250 $158,250 $158,250 $158,250 $1,912,500 G& A $132,925 $93,550 $93,550 $98,550 $93,550 $93,550 $93,550 $93,550 $93,550 $94,550 $94,550 $94,550 $1,169,975 Oper. Expenses $214,575 $206,850 $238,500 $275,150 $301,800 $271,800 $614,883 $539,883 $539,883 $510,883 $585,883 $660,883 $4,960,975 Oper. Income ($214,575) ($206,850) ($238,500) ($275,150) ($301,800) ($271,800) ($614,883) ($539,883) ($539,883) $364,117 $726,617 $1,089,117 ($1,023,475) Depreciation Expense $1,389 $2,222 $3,056 $3,889 $4,722 $4,722 $6,806 $6,806 $6,806 $6,806 $6,806 $6,806 $60,833 Interest Inc./(Exp.) ($32)
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 12 pages?

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

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors