Question: I am stuck on this homework problem. Please help! Please prepare a Pro Forma Financial Sheet for the worst, expected, and best outcomes for 12

Please prepare a Pro Forma Financial Sheet for the worst, expected, and best outcomes for 12 months with the following information. You have 1,000 used cars on hand. The cars range in price from $5,000 to $75,000. Your COGS is 80% of your sales price-no matter the car. Repairs can run from $100.00 to $5,000. Rent is $2,500 per month. You have a loan payment of $4,000 per month. Income taxes are 10%. You have three salaried employees. A Category Worst, Expected, Best (You are to provide a Sales Revenue $ Cost of Goods Sold (COGS) $ Gross Profit $ General Expenses $ $ *Rent Category Worst, Expected, Best (You are to provide all 3 outc Sales Revenue $ Cost of Goods Sold (COGS) $ Gross Profit $ General Expenses $ *Rent $ *Salaries $ en *Repair Expenses $ *Marketing Expenses $ ho *Marketing Expenses $ Loan Repayment $ Utilities $ Other Earnings Before Income Tax $ Income Tax Expense $ Net Profit $
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
