USA: +1(669)289-8683 
Sign in
course_assignment xcourse_project_budget_proposal_template1_1 xbudget_proposal_workbook2.xlsxbudget_proposal_workbook_week_42.xlsx
my week 1 and two complete as well as the documents you requested. The 4th item is the example of the workbook the teacher provided.
1
5
Acousti-cal
Budget Proposal
For
2012-2016
BUSN-334
Summer
Professor: Marty Mcfly
University
Table of Contents
Section
Title
Subsection
Title
Page Number
1.0
Executive summary
3
2.0
Sales Forecast
2.1
Sales Forecast
3
2.2
Methods and Assumptions
3
3.0
Capital Expenditure Budget
4.0
Investment Analysis
4.1
Cash flows
4.2
NPV Analysis
4.3
Rate of Return Calculations
4.4
Payback Period Calculations
5.0
Pro Forma Financial Statements
5.1
Pro Forma Income Statement
5.2
Pro-Forma Cash flow Statement
5.3
Pro-Forma Balance Sheets
6.0
Works Cited
7.0
Appendices
7.1
Appendix 1: [description]
7.2
Appendix 2:
[description] etc
(
1.0 Executive Summary
)
Beginning in 1972, Lee Deshler offered Florida’s first on-site calibration service. The company grew to include additional offices and states, which became the Trilogy Group. Trilogy Group includes Med-Acoustics and Tele-Acoustics, Charlotte, serves and supports the entire Southeastern US. Lee passed away in 1992 and in Florida, the second and third generation of the Deshler Family continues on the tradition that Lee created. Did you know that TELE-ACOUSTICS, Florida is… A founding member of NASED. The calibration quality assurance standard that the manufacturers require to insure calibration quality assurance The only NASED Certified Member in Florida that provides this assurance An award winning company, by both the manufacturers and clients served The preferred service provider for the leading manufacturers TELE-ACOUSTICS, FL is your one-stop-shop that sells and services instruments from the world’s most respected manufacturers. Our Family appreciates the opportunity to serve you, and we look forward to hear from you. Tim, Mike & Kevin Deshler
(
2.0 Sales Forecast
)
Briefly introduce the sales forecast section.
2.1 Sales Forecast
Sales are expected to rise at a rate of 5% a year. With the hearing industry growing in the state of Florida yearly due to population increase it is fair to say sales will grow as well. More and more individuals are turning to help for their hearing care.
Year 1
Year 2
Year 3
Year 4
Year 5
% yrly increase in sales
0
3%
4%
5%
6%
Total sales forecasted for 5 years
$1,500,000.00
$1,545,000.00
$1,606,800.00
$1,687,140.00
$1,788,368.40
2.2 Methods and Assumptions
In order to come to these conclusions I used the latest US census as well as posted industry numbers on individual web pages. On average the industry tends to gain a percentage point a year so my initial thought of 5% a year was a little off. The industry however is poised to make a profit increase yearly with no sign of a fall. Many people are now turning for help for their hearing due to the decrease in hearing aid size as well as technology increases in society. No longer is it strange to wear an electronic device on a person’s ear. With the increase in demand for the hearing aid we will also see an increase in the demand of instrumentation. This is where we come in.
(
3.0 Capital Expenditure Budget
)
Here you should provide a screenshot of your capital expenditure budget, also listing the sources of data and assumptions that led to each line item in table format. Briefly describe the total investment and, if necessary, why major items are necessary to achieve the company’s strategy.
(
4.0 Investment Analysis
)
Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it.
4.1 Cashflows
Provide an excel spreadsheet screenshot that shows how you arrive at the net cash flows for each period in your planning horizon and describe its highlights.
4.2 NPV Analysis
Provide a screen shot of your Excel NPV Analysis here, and describe its highlights.
4.3 Rate of Return
Provide a screen shot of your IRR and Accounting Rate of Return calculations here, and explain the highlights.
4.4 Payback Period
Provide a screen shot of your Excel calculation of the payback period for this venture.
(
5.0 Pro-Forma Financial Statements
)
Briefly introduce this section here.
5.1 Pro-Forma Income Statement
Describe key figures and assumptions from the income statement, such as important profit or sales figures and their causes. Also, provide a screen shot of your pro-forma income statement.
5.2 Pro-Forma Cash Flow Statement
Provide a screen shot of the cash flow statement and describe the impact of the budget on cash balances.
5.3 Pro-Forma Balance Sheets
Provide a screen shot of your balance sheets, and describe key figures they contain.
(
6
.0
Works Cited
)
List any sources you cited in the body of your report.
(
7.0
Appendi
ces
)
NOTE: Start this section at the top of a new page.
This section of the budget proposal is where you’ll attach all of the supporting materials that you’ve referenced in the preparation of your plan, and that is too detailed or extensive to be included in the body of the report. Use this page to separate the appendices from the text in the body of your report. Make certain that you update the table of contents to include the title of each exhibit in the appendix and its page number.
7.1 Appendix 1: [put a description here]
7.2 Appendix 1: [put a description here]
7.3 Appendix 1: [put a description here]
Your Company Name
Your Company Name
Budget Proposal
For
[Enter Years Here]
BUSN-278
[Term]
Professor[name]
DeVry University
Table of Contents
|
Section |
Title |
Subsection |
Page Number |
|
| 1.0 | Executive summary | |||
| 2.0 | Sales Forecast | |||
| 2.1 | ||||
| 2.2 | Methods and Assumptions | |||
| 3.0 | Capital Expenditure Budget | |||
| 4.0 | Investment Analysis | |||
| 4.1 | Cash flows | |||
| 4.2 | NPV Analysis | |||
| 4.3 | Rate of Return Calculations | |||
| 4.4 | Payback Period Calculations | |||
| 5.0 | Pro Forma Financial Statements | |||
| 5.1 | Pro Forma Income Statement | |||
| 5.2 | Pro-Forma Cash flow Statement | |||
| 5.3 | Pro-Forma Balance Sheets | |||
| 6.0 | Works Cited | |||
| 7.0 | Appendices | |||
| 7.1 | Appendix 1: [description] | |||
| 7.2 |
Appendix 2: [description] etc |
[Please put page numbers in the last column of the table of contents above, as they apply to your finished assignment. Do this after your project is complete. Also, remove this text and all text that is in italics in this template when finished your project.]
[Also, please submit your Excel Spreadsheet which shows your supporting calculations]
(
1.0 Executive Summary
)
The first paragraph of this executive summary should give a brief description of the business to which this budget applies. Very briefly describe the products and services of this company, the geographical or demographics of the customers it serves, and why people purchase the main product of this business. Much or all of this will be found in the Business Profile provided to you. Please use your own words, and please do not simply copy and paste the explanation in the course materials. Make assumptions if necessary.
Also, provide a second paragraph which describes how the budget supports the company’s strategy.
Finally, provide a third paragraph where you summarize the key points from your budget, including the planning horizon, the amount of up-front investment, the NPV, Payback and IRR of the project, as well as key figures from your income statement, cash flow statement, and balance sheet.
Remember, this is not a thesis or introduction of what you will talk about – it contains the major, specific content of each section. The second and third paragraph should be written after you have completed all other sections of this template.
As you complete sections of this template, please remove all italicized text in all sections of this template and replace it with your own or you will lose points!
(
2.0 Sales Forecast
)
Briefly introduce the sales forecast section.
2.1 Sales Forecast
Here you should include a simple table showing the years and the total sales for each year, along with a brief explanation of why sales are expected to rise, fall, change, or stay the same in certain years. Provide a brief explanation of the sales forecast, indicating why you expect sales to rise or fall during the planning horizon. Your explanation should be consistent with the trends and changes in sales found in your table:
Year 1
Year 2
Year 3
Year 4
Year 5
Sales
2.2 Methods and Assumptions
Here you should describe how you arrived at your sales forecast in section 2.1. You should also provide any detailed calculations that led you to the sales forecast values. You should also summarize any research or figures that led you to make this sales forecast.
(
3.0 Capital Expenditure Budget
)
Here you should provide a screenshot of your capital expenditure budget, also listing the sources of data and assumptions that led to each line item in table format. Briefly describe the total investment and, if necessary, why major items are necessary to achieve the company’s strategy.
(
4.0 Investment Analysis
)
Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it.
4.1 Cashflows
Provide an excel spreadsheet screenshot that shows how you arrive at the net cash flows for each period in your planning horizon and describe its highlights.
4.2 NPV Analysis
Provide a screen shot of your Excel NPV Analysis here, and describe its highlights.
4.3 Rate of Return
Provide a screen shot of your IRR and Accounting Rate of Return calculations here, and explain the highlights.
4.4 Payback Period
Provide a screen shot of your Excel calculation of the payback period for this venture.
(
5.0 Pro-Forma Financial Statements
)
Briefly introduce this section here.
5.1 Pro-Forma Income Statement
Describe key figures and assumptions from the income statement, such as important profit or sales figures and their causes. Also, provide a screen shot of your pro-forma income statement.
5.2 Pro-Forma Cash Flow Statement
Provide a screen shot of the cash flow statement and describe the impact of the budget on cash balances.
5.3 Pro-Forma Balance Sheets
Provide a screen shot of your balance sheets, and describe key figures they contain.
(
6
.0
Works Cited
)
List any sources you cited in the body of your report.
(
7.0
Appendi
ces
)
NOTE: Start this section at the top of a new page.
This section of the budget proposal is where you’ll attach all of the supporting materials that you’ve referenced in the preparation of your plan, and that is too detailed or extensive to be included in the body of the report. Use this page to separate the appendices from the text in the body of your report. Make certain that you update the table of contents to include the title of each exhibit in the appendix and its page number.
7.1 Appendix 1: [put a description here]
7.2 Appendix 1: [put a description here]
7.3 Appendix 1: [put a description here]
Instructions
| BUSN-278 Budgeting and Forecasting Template Instructions |
| Use this spreadsheet structure to lay out the various sections of your project. |
| The purpose of this spreadsheet is to make it easy for your professor to locate the |
| various sections of your project. Please don’t alter the Worksheet Tabs or titles. |
| After you finish your calculations in this spreadsheet, you will have to |
| create a written report where you take screenshots from this spreadsheet |
| and put them in the Budget Proposal Template, along with necessary |
| explanations. Detailed instructions for how to write the report |
| are found in the Budget Proposal Template, a word document. |
2.1 & 2.2 Sales Forecast
| Put your sales forecasting calculations here. |
3.0 Capital Expenditure Budget
4.1 Cashflows
| Put your detailed cash inflows and cash outflows here, also showing net cash flow. |
4.2 NPV Analysis
| Create an NPV Analysis here. |
4.3 Rate of Return Calculations
| Show your rate of return calculations in this worksheet. |
4.4 Payback Period Calculations
| Show your payback period calculations here. |
5.0 Pro Forma Financials
| Put your Pro-Forma Income Statement, Balance sheet and statement of cash flows here, along with any other supporting calculations or schedules. |
>Instructions
BUSN-278 Budgeting and Forecasting Template Instructions
Use this spreadsheet structure to lay out the various sections of your project.
The purpose of this spreadsheet is to make it easy for your professor to locate the
various sections of your project. Please don’t alter the Worksheet Tabs or titles.
After you finish your calculations in this spreadsheet, you will have to
create a written report where you take screenshots from this spreadsheet
and put them in the Budget Proposal Template, along with necessary
explanations. Detailed instructions for how to write the report
are found in the Budget Proposal Template, a word document.
2.
& 2.2 Sales Forecast
| Put your sales forecasting calculations here. | ||||||||||
| General Information | ||||||||||
| Industry recorded pizza sales for 1 yr @ | $1 | 0 | $ | 3 | ||||||
| Independently owned % of yrly pizza sales | 5 | |||||||||
| Number of restaurants in US | 6 | 4 | ||||||||
| Number of restaurants in Orlando, Florida | 221 | |||||||||
| number of peak hours in a day between 10am-9pm | ||||||||||
| Americans age 18-24 eat pizza at least 3x a wk | 21% | |||||||||
| 65 or older only eat 1 pizza a month | 7% | |||||||||
| Total | ||||||||||
| 1 yr sales | $37,000,000,000 | 67554 | ||||||||
| Total possible sales | $ | 547 | ||||||||
| Independent % of sales | ||||||||||
| Total possible sales per independent owner | $279,332.09 | |||||||||
| Total sales broken down by $10/$7 | ||||||||||
| 37,000,000,000.00 | Year | Year 2 | Year 3 | Year 4 | Year 5 | |||||
| Pizza price | % yrly increase in sales | 3% | 4% | 5% | 6% | |||||
| Units sold | 3,700,000,000.00 | Total sales forecasted for 5 years | $414,616.45 | $427,054.95 | $ | 444,137 | $ | 466,344 | $494,324.64 | |
| Units sold per pizza company | 54,771.00 | |||||||||
| Units sold by independent companies | 27,933.21 | |||||||||
| Sales by independent @ $7 | $ 195,532.46 | |||||||||
| Gaming sold at $4 per household average | $ 219,083.99 | |||||||||
| $ 414,616.45 |
3.0 Capital Expenditure Budget
| Equipment | Miscellaneous | ||||||||
| 2 ovens | $8,327.00 | 140 dish set | $225.00 | ||||||
| soda fountain bar | $4,194.00 | cutlery/trays/spoons/shakers/forks | $339.00 | ||||||
| salad/dessert bar | $23,717.00 | cookware | $200.00 | ||||||
| commercial | refrigerator | $3,126.84 | cups | $300.00 | |||||
| cash registers | $1,500.00 | busing cart/tubs | $2,727.00 | ||||||
| 6 video game machines | $22,750.00 | filing fee | $155.00 | ||||||
| microwave | $90.00 | $3,946.00 | |||||||
| sink | $100.00 | ||||||||
| $99.00 | |||||||||
| 20 tables/chairs | $12,380.00 | ||||||||
| dishwasher | $2,822.00 | ||||||||
| $79,105.84 | |||||||||
| Furniture | Facility Costs | ||||||||
| Office desk | $387.00 | Renovations | $1 | 5,000 | |||||
| cabinets | $160.00 | Advertising | $ | 23,000 | |||||
| $547.00 | Rent | $ | 70,000 | ||||||
| $108,000.00 | |||||||||
| Capital Expenditures Budget | |||||||||
| $79, 106.00 | |||||||||
| Furniture/Fixtures | |||||||||
| $112,493.00 |
4.1 Cashflows
| Put your detailed cash inflows and cash outflows here, also showing net cash flow. | |||||||||||||
| Cash Flow Budget Worksheet | |||||||||||||
| Papa Geo’s | |||||||||||||
| 2010 | 2011 | 2012 | 2013 | 2014 | |||||||||
| Beginning Cash Balance | $503,251 | ERROR:#NAME? | |||||||||||
| Cash Inflows | |||||||||||||
| Loan Proceeds | 200,000 | ||||||||||||
| Sales & Receipts | 414,416 | 427,055 | 494,325 | 2,246,277 | |||||||||
| Total Cash Inflows | $614,416 | $427,055 | $444,137 | $466,344 | $494,325 | $2,446,277 | |||||||
| Available Cash Balance | $930,306 | ||||||||||||
| Cash Outflows (Expenses): | |||||||||||||
| 12,500 | 73,000 | ||||||||||||
| Health | Insurance | 15,808 | 79,040 | ||||||||||
| 1,000 | |||||||||||||
| Interest | 11,590 | 10,662 | 9,676 | 8,630 | 7,518 | 48,077 | |||||||
| Payroll | 210,080 | 1,050,400 | |||||||||||
| Rent or Lease | 3 | 50,000 | |||||||||||
| Utilities & Telephone | 9,000 | 45,000 | |||||||||||
| 15,000 | |||||||||||||
| Inventories | 42,706 | 44,414 | 46,634 | 49,433 | 52,398 | 235,585 | |||||||
| 79,106 | |||||||||||||
| Credit card fees | 10,360 | 10,676 | 11,103 | 11,659 | 12,358 | 56,157 | |||||||
| Subtotal | $488,197 | $384,140 | $385,802 | $388,109 | $390,663 | $2,036,911 | |||||||
| Other Cash Out Flows: | |||||||||||||
| Loan Principal | 15,054 | 15,983 | 16,969 | 18,015 | 19,127 | 85,148 | |||||||
| Owner’s Draw | 60,000 | 230,000 | |||||||||||
| $15,054 | $65,983 | $66,969 | $78,015 | $89,127 | $315,148 | ||||||||
| Total Cash Outflows | $450,123 | $452,771 | $466,124 | $479,789 | $2,352,059 | ||||||||
| Ending Cash Balance | $111,165 | $480,183 |
4.2 NPV Analysis
| Create an NPV Analysis here. | ||||||||
| Discount Factor | ||||||||
| 10% | Present Value | |||||||
| 111,165.03 | 0.9091 | 101,060.13 | ||||||
| 480,183.37 | 0.8264 | 396,823.54 | ||||||
| 441,489.40 | 0.7513 | 331,690.99 | ||||||
| 452,990.73 | 0.603 | 273,153.41 | ||||||
| 480,659.20 | 0.6209 | 298,441.30 | ||||||
| 1,966,487.73 | 1,401,169.36 | |||||||
| Present Value of | Cash inflows | Initial Investment | Net Present Value | |||||
| 200,000.00 | 1,201,169.36 |
4.3 Rate of Return Calculations
| Show your rate of return calculations in this worksheet. | |
| Total for equipment | 66,436.00 |
| Depreciation | 13,287.20 |
| 1,966,488.00 | |
| ARR | 9.77 |
| Annual Cash Inflow | |
| IRR | 0.1017 |
4.4
Payback Period
Calculations
| Show your payback period calculations here. | ||||
| Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 |
| Capital Investment | ||||
| 1.799 | 0.417 | 0.453 | 0.442 | 0.416 |
| Total Payback period over 5 years | 3.526 |
5.0 Pro Forma Financials
| Put your Pro-Forma Income Statement, Balance sheet and statement of cash flows here, along with any other supporting calculations or schedules. |
