1
answer
0
watching
194
views
28 Sep 2019
For this assignment you will create a financial business plan thatwill tie together an income statement, a purchases budget, a cashbudget, and a pro forma balance sheet. The completed assignmentshould be printed on two pages. You must also turn in a âhardâ copyof your report.
The first step is to produce the income statement.
Income Statement
To complete this first step, we need to project monthly sales andexpenses. This requires estimates of monthly sales volume, sellingprice, and cost behaviors. The following are the estimates youshould use in developing your model.
Annual sales: 18,000 pizzas
Monthly sales pattern:
January 8% April 10.5% July 4% October 10.5%
February 10% May 7% August 6% November 9%
March 11% June 6% September 9.5% December 8.5%
Selling Price: $11.50 per pizza
Annual cost behaviors:
Fixed Variable (per pizza)
Ingredients $ 0 $3.00
Salaries & wages 48,000 .50
Advertising 3,000 .00
Depreciation 9,000 .00
Utilities 3,000 .25
Supplies 0 .15
Local taxes 4,200 .00
Insurance 2,400 .00
Miscellaneous 2,400 .10
The above fixed expenses are for the entire year. Assume fixedexpenses are incurred evenly throughout the year.
Your assignment is to produce a computer spreadsheet that willgenerate monthly income statements for the entire year. Thespreadsheet should allow for easy manipulation of annual volume,selling price, and changes in cost behavior.
Purchases budget, balance sheet, and cash budget
After completing the projected income statement, you are now ableto prepare the purchases budget, cash budget, and balance sheet.The purchasing budget is used to plan raw material (ingredient)purchases. The purpose of the cash budget is to predict our cashposition at the end of each period, thus allowing us to planshort-term borrowing if it is needed. We create the cash budget bydetermining the amount and timing of cash receipts and cashpayments. To do this, we make certain assumptions about expectedcash flow patterns. The following assumptions apply to the PizzaShoppe:
1. Revenues are collected in the month of sale.
2. Ingredients purchased are paid as follows:
⢠Forty percent in the month of purchase.
⢠Sixty percent in the month following the purchase.
3. Our policy is to have enough ingredients on hand at the end ofeach month to satisfy 20% of the next monthâs cost ofingredients.
4. Salaries and wages are paid as follows:
⢠Seventy-five percent in the month incurred.
⢠Twenty-five percent in the following month.
5. Advertising is paid in the month incurred.
6. Utilities are paid in the month after itâs incurred.
7. Supplies are purchased and paid in the month before use.
8. Insurance is paid 50% in January and 50% in July.
9. The local taxes are paid 50% in April and 50% in October.
10. All miscellaneous expenses are paid in the month after they areincurred.
11. The long-term loan carries a 12% interest rate.
12. The owner withdraws $3,000 per month.
In addition to the amount and timing of cash flows, we need to knowwhat our initial financial position is. Financial position iscaptured by the balance sheet. The balance sheet is a listing ofour resources (assets), our obligations (liabilities), and the networth of the business (ownerâs equity). The balance sheet for thePizza Shoppe on January 1, just after we purchase it, is asfollows:
ASSETS LIABILITIES
Cash $ 100 Accounts Payable $ 0
Ingredients inventory 700 Salaries & Wages Payable 0
Supplies inventory 216 Utilities payable 500
Prepaid taxes 0 Taxes payable 0
Prepaid insurance 0 Misc. expenses payable 0
Equipment & fixtures 30,000 Short-term bank loan 0
Less: Accumulated deprec. 0 Long-term bank loan 90,000
Building 60,000 Total Liabilities $ 90,500
Less: Accumulated deprec. 0
Land 29,500 OWNERS EQUITY $ 30,016
Total Assets $120,516
TOTAL LIABILITIES & O.E. $120,516
For this assignment you will create a financial business plan thatwill tie together an income statement, a purchases budget, a cashbudget, and a pro forma balance sheet. The completed assignmentshould be printed on two pages. You must also turn in a âhardâ copyof your report.
The first step is to produce the income statement.
Income Statement
To complete this first step, we need to project monthly sales andexpenses. This requires estimates of monthly sales volume, sellingprice, and cost behaviors. The following are the estimates youshould use in developing your model.
Annual sales: 18,000 pizzas
Monthly sales pattern:
January 8% April 10.5% July 4% October 10.5%
February 10% May 7% August 6% November 9%
March 11% June 6% September 9.5% December 8.5%
Selling Price: $11.50 per pizza
Annual cost behaviors:
Fixed Variable (per pizza)
Ingredients $ 0 $3.00
Salaries & wages 48,000 .50
Advertising 3,000 .00
Depreciation 9,000 .00
Utilities 3,000 .25
Supplies 0 .15
Local taxes 4,200 .00
Insurance 2,400 .00
Miscellaneous 2,400 .10
The above fixed expenses are for the entire year. Assume fixedexpenses are incurred evenly throughout the year.
Your assignment is to produce a computer spreadsheet that willgenerate monthly income statements for the entire year. Thespreadsheet should allow for easy manipulation of annual volume,selling price, and changes in cost behavior.
Purchases budget, balance sheet, and cash budget
After completing the projected income statement, you are now ableto prepare the purchases budget, cash budget, and balance sheet.The purchasing budget is used to plan raw material (ingredient)purchases. The purpose of the cash budget is to predict our cashposition at the end of each period, thus allowing us to planshort-term borrowing if it is needed. We create the cash budget bydetermining the amount and timing of cash receipts and cashpayments. To do this, we make certain assumptions about expectedcash flow patterns. The following assumptions apply to the PizzaShoppe:
1. Revenues are collected in the month of sale.
2. Ingredients purchased are paid as follows:
⢠Forty percent in the month of purchase.
⢠Sixty percent in the month following the purchase.
3. Our policy is to have enough ingredients on hand at the end ofeach month to satisfy 20% of the next monthâs cost ofingredients.
4. Salaries and wages are paid as follows:
⢠Seventy-five percent in the month incurred.
⢠Twenty-five percent in the following month.
5. Advertising is paid in the month incurred.
6. Utilities are paid in the month after itâs incurred.
7. Supplies are purchased and paid in the month before use.
8. Insurance is paid 50% in January and 50% in July.
9. The local taxes are paid 50% in April and 50% in October.
10. All miscellaneous expenses are paid in the month after they areincurred.
11. The long-term loan carries a 12% interest rate.
12. The owner withdraws $3,000 per month.
In addition to the amount and timing of cash flows, we need to knowwhat our initial financial position is. Financial position iscaptured by the balance sheet. The balance sheet is a listing ofour resources (assets), our obligations (liabilities), and the networth of the business (ownerâs equity). The balance sheet for thePizza Shoppe on January 1, just after we purchase it, is asfollows:
ASSETS LIABILITIES
Cash $ 100 Accounts Payable $ 0
Ingredients inventory 700 Salaries & Wages Payable 0
Supplies inventory 216 Utilities payable 500
Prepaid taxes 0 Taxes payable 0
Prepaid insurance 0 Misc. expenses payable 0
Equipment & fixtures 30,000 Short-term bank loan 0
Less: Accumulated deprec. 0 Long-term bank loan 90,000
Building 60,000 Total Liabilities $ 90,500
Less: Accumulated deprec. 0
Land 29,500 OWNERS EQUITY $ 30,016
Total Assets $120,516
TOTAL LIABILITIES & O.E. $120,516
The first step is to produce the income statement.
Income Statement
To complete this first step, we need to project monthly sales andexpenses. This requires estimates of monthly sales volume, sellingprice, and cost behaviors. The following are the estimates youshould use in developing your model.
Annual sales: 18,000 pizzas
Monthly sales pattern:
January 8% April 10.5% July 4% October 10.5%
February 10% May 7% August 6% November 9%
March 11% June 6% September 9.5% December 8.5%
Selling Price: $11.50 per pizza
Annual cost behaviors:
Fixed Variable (per pizza)
Ingredients $ 0 $3.00
Salaries & wages 48,000 .50
Advertising 3,000 .00
Depreciation 9,000 .00
Utilities 3,000 .25
Supplies 0 .15
Local taxes 4,200 .00
Insurance 2,400 .00
Miscellaneous 2,400 .10
The above fixed expenses are for the entire year. Assume fixedexpenses are incurred evenly throughout the year.
Your assignment is to produce a computer spreadsheet that willgenerate monthly income statements for the entire year. Thespreadsheet should allow for easy manipulation of annual volume,selling price, and changes in cost behavior.
Purchases budget, balance sheet, and cash budget
After completing the projected income statement, you are now ableto prepare the purchases budget, cash budget, and balance sheet.The purchasing budget is used to plan raw material (ingredient)purchases. The purpose of the cash budget is to predict our cashposition at the end of each period, thus allowing us to planshort-term borrowing if it is needed. We create the cash budget bydetermining the amount and timing of cash receipts and cashpayments. To do this, we make certain assumptions about expectedcash flow patterns. The following assumptions apply to the PizzaShoppe:
1. Revenues are collected in the month of sale.
2. Ingredients purchased are paid as follows:
⢠Forty percent in the month of purchase.
⢠Sixty percent in the month following the purchase.
3. Our policy is to have enough ingredients on hand at the end ofeach month to satisfy 20% of the next monthâs cost ofingredients.
4. Salaries and wages are paid as follows:
⢠Seventy-five percent in the month incurred.
⢠Twenty-five percent in the following month.
5. Advertising is paid in the month incurred.
6. Utilities are paid in the month after itâs incurred.
7. Supplies are purchased and paid in the month before use.
8. Insurance is paid 50% in January and 50% in July.
9. The local taxes are paid 50% in April and 50% in October.
10. All miscellaneous expenses are paid in the month after they areincurred.
11. The long-term loan carries a 12% interest rate.
12. The owner withdraws $3,000 per month.
In addition to the amount and timing of cash flows, we need to knowwhat our initial financial position is. Financial position iscaptured by the balance sheet. The balance sheet is a listing ofour resources (assets), our obligations (liabilities), and the networth of the business (ownerâs equity). The balance sheet for thePizza Shoppe on January 1, just after we purchase it, is asfollows:
ASSETS LIABILITIES
Cash $ 100 Accounts Payable $ 0
Ingredients inventory 700 Salaries & Wages Payable 0
Supplies inventory 216 Utilities payable 500
Prepaid taxes 0 Taxes payable 0
Prepaid insurance 0 Misc. expenses payable 0
Equipment & fixtures 30,000 Short-term bank loan 0
Less: Accumulated deprec. 0 Long-term bank loan 90,000
Building 60,000 Total Liabilities $ 90,500
Less: Accumulated deprec. 0
Land 29,500 OWNERS EQUITY $ 30,016
Total Assets $120,516
TOTAL LIABILITIES & O.E. $120,516
Nestor RutherfordLv2
28 Sep 2019