Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you help me calculate interest, and profit before taxes based on this projected monthly income statement? 2X Delete . === = += $ %)
Can you help me calculate interest, and profit before taxes based on this projected monthly income statement?
2X Delete . === = += $ %) 48-29 Conditional Format as Cell Formatting Table Styles Styles Format Clipboard IS Font IS Alignment Number Cells B19 A D E F G H 1 Vazquez Bookkeeping 2 Income Statement 3 Monthly Projection 4 October November December January February March 5 Sales $15,000 $16,500 $18,000 $19,500 $21,000 $22,500 6 Cost of sales $7,500 $8,250 $9,000 $9,750 $10,500 $11,250 7 Gross Margin $7,500 $8,250 $9,000 $9,750 $10,500 $11,250 8 9 Expenses 10 Internet $500 $500 S500 $500 $500 $500 11 Interest $100 $100 $100 $100 $100 $100 12. Office Supplies $50 $50 $50 $50 13 Prepaid Insurance $200 $200 $200 $200 $200 $200 14 Software $300 $300 $300 $300 $300 $300 15 Advertising $100 $20 $20 $20 16 Total Operating Expenses 1,180 $1,170 $1170 $1,170 $1,170 $1,170 17 Profit Before Interest and Taxes $6,320 $7,080 $7,830 $8,580 $9,330 $10,080 18 Profit Before Taxes 19 Taxes (20%) 20 Net Income 21 Start Up Costs Income Statement + $50 $50 $20 $20 BI Type here to search L M N O P 0 ng May April $24,000 $12,000 $12,000 June July August September 25,500 $27,000 $28,500 $30,000 $31,500 $12,750 $13,500 $14,250 $15,000 $15,750 $12.750 $13,500 $14,250 $15,000 $15,750 $500 $100 $50 $200 $300 $20 $1,170 $10,830 $500 $500 $500 $500 $100 $100 $100 $100 $50 $50 $50 $50 $200 $200 $200 $200 $300 $300 $300 $300 $20 $20 $20 $20 $1,170 $1,170 $1,170 $1,170 $11,580 $12,330 $13,080 $13,830 $500 $100 $50 $200 $300 $20 $1,170 $14,580 W qb 2X Delete . === = += $ %) 48-29 Conditional Format as Cell Formatting Table Styles Styles Format Clipboard IS Font IS Alignment Number Cells B19 A D E F G H 1 Vazquez Bookkeeping 2 Income Statement 3 Monthly Projection 4 October November December January February March 5 Sales $15,000 $16,500 $18,000 $19,500 $21,000 $22,500 6 Cost of sales $7,500 $8,250 $9,000 $9,750 $10,500 $11,250 7 Gross Margin $7,500 $8,250 $9,000 $9,750 $10,500 $11,250 8 9 Expenses 10 Internet $500 $500 S500 $500 $500 $500 11 Interest $100 $100 $100 $100 $100 $100 12. Office Supplies $50 $50 $50 $50 13 Prepaid Insurance $200 $200 $200 $200 $200 $200 14 Software $300 $300 $300 $300 $300 $300 15 Advertising $100 $20 $20 $20 16 Total Operating Expenses 1,180 $1,170 $1170 $1,170 $1,170 $1,170 17 Profit Before Interest and Taxes $6,320 $7,080 $7,830 $8,580 $9,330 $10,080 18 Profit Before Taxes 19 Taxes (20%) 20 Net Income 21 Start Up Costs Income Statement + $50 $50 $20 $20 BI Type here to search L M N O P 0 ng May April $24,000 $12,000 $12,000 June July August September 25,500 $27,000 $28,500 $30,000 $31,500 $12,750 $13,500 $14,250 $15,000 $15,750 $12.750 $13,500 $14,250 $15,000 $15,750 $500 $100 $50 $200 $300 $20 $1,170 $10,830 $500 $500 $500 $500 $100 $100 $100 $100 $50 $50 $50 $50 $200 $200 $200 $200 $300 $300 $300 $300 $20 $20 $20 $20 $1,170 $1,170 $1,170 $1,170 $11,580 $12,330 $13,080 $13,830 $500 $100 $50 $200 $300 $20 $1,170 $14,580 W qbStep 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