Instructions: For this Assignment, estimate a Profit & Loss Statement for Scenario A OR Scenario B as seen below.

What general observations can you make about the company based on the profit and loss results? Note specific areas of concern and/or identify strengths. Does the company need to borrow money at the end of the year to meet expenses? Explain why or why not? If the company does need to borrow money, how much would you recommend and from what source(s)? If the company does not need to borrow money, what other recommendations might you have based on your analysis of the results? Make sure to provide detailed explanations in which you carefully consider all aspects of the profit and loss spreadsheet.

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .font5 {color:red; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0;} .xl16 {border:.5pt solid windowtext;}

Chosen Assumption: Insert A or B here	October	November	December
Gross Sales
Inventory Purchases (cost of goods sold)
Net Sales (DO NOT ENTER ANY INFO.)	0	0	0
Cash Disbursement to Owner
Wages and Salaries
Rental Expenses
Utilities
Tax Prepayment
Interest on Bank Note
Total Expenses (DO NOT ENTER ANY INFO.)	0	0	0
Profit (DO NOT ENTER ANY INFO.)	0	0	0

Submit your completed estimated P&L spreadsheet and minimum 250-word, double-spaced, APA-formatted response.

Scenario A: Unit 10 Assignment Assumption

Assume monthly gross sales are $280,000 October, $290,000 November, and $345,000 December.

Assume Inventory purchases are $70,000 October, $75,000 November, and $95,000 December.

Assume the owner gets a cash disbursement of $45,000 in October, $51,000 in November, and $52,000 in December.

Assume wages and salaries are 48% of gross monthly sales.

Assume rent is $9,500 a month.

Assume utilities are 5% of gross monthly sales.

Assume a tax prepayment of $16,000 in October.

Assume bank interest on the note is $1,500/month.

Scenario B: Unit 10 Assignment Assumption

Assume monthly gross sales are $275,000 October, $310,000 November, and $325,000 December.

Assume Inventory purchases are $60,000 October, $75,000 November, and $85,000 December.

Assume the owner gets a cash disbursement of $30,000 in October, $35,000 in November, and $40,000 in December.

Assume wages and salaries are 50% of gross monthly sales.

Assume rent is $10,000 a month.

Assume utilities are 10% of gross monthly sales.

Assume a tax prepayment of $12,000 in October.

Assume bank interest on the note is $2,500/month.