Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 ) Include a 3 - line header consisting of the name of the company, the title of the report, and the date period, on
Include a line header consisting of the name of the company, the title of the report, and the date period, on each sheet.
The first sheet should contain the budgetary assumptions, and the second and third sheets should contain the master budget. Name the sheets ie dont just leave them as Sheet and Sheet Whenever possible, make the assumptions on the first sheet cells that you can reference when you fill out the second sheet!
The budget is monthly for and the Fiscal Year is the same as the calendar year. Make each month of a separate column in the spreadsheet. Assume this is the first year of operation, so there were no sales or expenses in
Calculate a Gross Profit line Sales less Cost of Goods Sold
Produce both an accrual budget and a cash budget on separate spreadsheets. For example, the second sheet can be the accrual budget and the third sheet could be the cash budget.
Break out expenses into fixed and variable expenses, and total separately ie have a line that has Total fixed expenses and Total variable expenses For simplicity, you can combine variable expenses and semivariable expenses into a variable expense category.
Calculate a Net Income Before Taxes line. Then, calculate taxes, and calculate a Net Income After Taxes line.
Make the spreadsheet easy to read and attractive looking! Be sure to underline totals and double underline the bottom line net income after tax Insert notations or comments as required to make the budget easy to understand.
Add a cell at the bottom of the accrual and cash budgets that totals up all Net Income After Tax for the year ie Total Net Income After Taxes
Assignment Assumptions:
CupcakesPalooza has a contract to sell cupcakes per day days per week, yearround to area grocery stores. The stores pay $ per cupcake.
All sales are on credit and it collects of all sales in the month of the sale, in the month after the sale, and the second month after the sale.
It costs CupcakesPalooza $ in direct materials and labor to sell the cupcakes to its customers. That is the companys cost of goods sold.
The company pays its sales force a commission equal to of sales.
The company also believes that its supplies expense is equal to $ per month plus of sales.
Advertising is $ per month, Depreciation is $ per month, and Utilities are $ per month.
The company purchased an insurance policy covering months for $ on January
All selling and administrative expenses are paid in the month they are incurred except for commissions that are paid in the month after they are earned and the insurance which is paid one year in advance.
The company is subject to a income tax rate. The company pays income taxes in the month after they are accrued expensed Complete in excel format
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started