Answer the following questions and submit the budget and the projection pages from the Excel file in the Course Materials. you need plan to start a new business, for example, you can decide to open restaurant, then follow the first file instruction and probably you need use the second files ratio to analysis( the data you need assume by yourself)

Building Financial Relationships

Name:

Answer the following questions and submit the budget and the projection pages from the Excel file in the Course Materials.
– Describe your business idea:
– What are your revenue assumptions?
– What are your major expense assumptions?

– Did you need to make adjustments to the cash flow section? How much of an investment would be needed to make the idea viable?

-Review the Gross Profit Margin and Net Profit (Loss) Margin for the 1st year and projection years.

Does the idea appear viable?

proj

New Focus Consulting
Projection Format
Sale % increase: Sale % increase: Sale % increase: Sale % increase: Sale % increase:
Projections 0% 0% 0% 0% 0%
Inflation Factor: Inflation Factor: Inflation Factor: Inflation Factor: Inflation Factor:
0% 0% 0% 0% 0%
Base Period(Budget) Period 1 Period 2 Period 3 Period 4 Period 5
Revenues – 0 – 0 – 0 – 0 – 0 – 0
– 0 – 0 – 0 – 0 – 0 – 0
Direct Expenses:
cost of goods sold – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0!
Gross Margin – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0!
Non-Direct Expenses
non-direct salaries – 0 – 0 – 0 – 0 – 0 – 0
additional staffing
taxes & benefits – 0 – 0 – 0 – 0 – 0 – 0
insurances – 0 – 0 – 0 – 0 – 0 – 0
occupancy costs – 0 – 0 – 0 – 0 – 0 – 0
additional space needs
consultants – 0 – 0 – 0 – 0 – 0 – 0
marketing – 0 – 0 – 0 – 0 – 0 – 0
reproduction – 0 – 0 – 0 – 0 – 0 – 0
supplies – 0 – 0 – 0 – 0 – 0 – 0
cleaning – 0 – 0 – 0 – 0 – 0 – 0
phones & utilities – 0 – 0 – 0 – 0 – 0 – 0
auto expense – 0 – 0 – 0 – 0 – 0 – 0
travel and entertainment – 0 – 0 – 0 – 0 – 0 – 0
dues and subscriptions – 0 – 0 – 0 – 0 – 0 – 0
education/training – 0 – 0 – 0 – 0 – 0 – 0
computer expense – 0 – 0 – 0 – 0 – 0 – 0
service fees – 0 – 0 – 0 – 0 – 0 – 0
interest expense – 0 – 0 – 0 – 0 – 0 – 0
corporate allocations – 0 – 0 – 0 – 0 – 0 – 0
depreciation – 0 – 0 – 0 – 0 – 0 – 0
Total Non-Direct Expenses – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0!
Net Income(Loss) – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0! – 0 ERROR:#DIV/0!

New Focus Consulting 2006

Budget & cash flow

New Focus Consulting
Budget
Jan Feb March April May June July Aug Sept Oct Nov Dec Total
Revenues – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 0.0
Direct Expenses:
cost of goods sold – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 ERROR:#DIV/0!
Gross Margin – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 ERROR:#DIV/0!
Non-Direct Expenses
non-direct salaries – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
taxes & benefits – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
insurances – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
occupancy costs – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
consultants – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
marketing – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
reproduction – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
supplies – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
cleaning – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
phones & utilities – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
delivery service – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
travel and entertainment – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
dues and subscriptions – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
education/training – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
computer expense – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
service fees – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
interest expense – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
corporate allocations – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
depreciation – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
Total Non-Direct Expenses – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
Net Income(Loss) – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 ERROR:#DIV/0!
New Focus Consulting
Cash Flow
Jan Feb March April May June July Aug Sept Oct Nov Dec
Beginning Cash – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
Net Income – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0
Co. Investment
Debt Proceeds
Fitup Costs
truck
Computers/phone
Equipment
building
Debt Payments
Net Operating Adj.
Depr. Add Back
Ending Cash Bal. – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0

New Focus Consulting 2006


What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."


“Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!”