Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me calculate interest, and profit before taxes based on this projected monthly income statement? 2X Delete . === = += $ %)

image text in transcribedimage text in transcribed

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 qb

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Debra C. Jeter, Paul Chaney

2nd Edition

0471218529, 978-0471218524

More Books

Students also viewed these Accounting questions

Question

9.7 List and briefly discuss four management development methods.

Answered: 1 week ago