Problem: I have a presentation that requires excel file (3 pages)
The data figure has to be accurate but it is sample company
1. Balance sheet for Jan 10
2. Current budget for 2010
3. Income statement for 3 years
Company made 9.7 mil in 07
Company made 15.5 mil in 08
Company made 47.2 mil in 09
ALL Expenses increased 22% from 2008 and 13% from 2007 Company pays out the following expense in 2009:
Accounts Receivable 47.2
Accounts Payable
Salaries & Commissions 680k year
Office Rent 26k/mo
Inventory 1.6 mil
Insurances & Licensees 8400/year
Travel 85k year
Conferences & Seminars 780k year
Legal 255k year
Goodwill 10% of revenues (same for all 3 years)
Advertising & Marketing 27% of revenues
Support Contracts 325k year
Investments 25.2 million (no investments for 07, 08
Research & Development 1.8mil
Taxes 30%