Homework 7.0

profilemegan.mcwafe04s6
EMG4006ExampleofSourceandUseofFundsStmtforChapter7-FinancialPlan1-2.xlsx

Sheet1

Expansion Plan - Source and Use of Funds Statement
Company:
Source of Funds
Source Amount
Management Team Investment  $      700,000
Line of Credit with PNC Bank (4% simple interest loan)  $        75,000
Total Funds Committed  $      775,000
Total Funds Required  $   1,225,000
Total Funds Needed from an Equity Investor  $      450,000
Use of Funds
Cost Item Amount
Office Facilities  $      210,000
Office and Computer Equipment  $        75,000
Staffing and Personnel  $        30,000
Sales and Marketing  $        50,000
Attorney Fees  $        15,000
Initial Inventory  $     645,000
Other (R&D and General Expenses)  $        50,000
Cash for Working Capital  $        50,000
Shortfall on Break Even Profitability During Initial Operations  $      100,000
Total Required Funds  $   1,225,000