Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please include formulas A B D E H 1 Income and Expenses 2 JAN FEB MAR APR MAY JUN TOTAL 3 4 INCOME Services -

image text in transcribedplease include formulas

A B D E H 1 Income and Expenses 2 JAN FEB MAR APR MAY JUN TOTAL 3 4 INCOME Services - Individual Services - Packages Merchandise Gift Certificates Misc TOTAL 5 1,890 4,100 4,480 5,590 4,300 2,240 4,900 8,820 2,390 3,000 6,750 3,030 2,000 2,420 4,500 6,700 4,300 3,000 3,000 5,500 7,300 4,300 4,500 3,700 5,700 9,750 5,700 3,900 6 5,000 4,300 7 8 9 JAN MAR APR MAY JUN TOTAL 10,000 1,200 400 10,000 800 10,000 800 400 10,000 750 10,000 750 400 400 400 10 EXPENSES 11 Rent 12 Advertising 13 Supplies 14 Cost of Goods 15 Payroll 16 Misc 17 TOTAL 10,000 1,500 400 400 6,000 500 400 400 400 400 6,000 300 400 6,000 430 6,500 6,500 6,000 200 700 640 18 19 NET INCOME $ 20 21 22 Use format painter to copy the format from cell B10 to cells B2:H2 23 24 Enter a formula in cell H3 to calculate the sum of cells B3:63, use the AutoSum 25 Copy the formula down to H8 26 Repeat steps in rows 24/25 in cells H11 to H17 27 28 Calculate NET INCOME for each month

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

Financial Markets And Institutions

Authors: Anthony Saunders, Marcia Cornett

7th Edition

1259919714, 978-1259919718

More Books

Students also viewed these Finance questions

Question

Find the derivative. f(x) 8 3 4 mix X O 4 x32 4 x32 3 -4x - x2

Answered: 1 week ago