Business, 04.03.2021 19:50, gabbystar517

Income Statement Project 2018 2019 2020
Revenue:
Book Sales
Ticket Sales
Total Revenue:
Expenses:
Salary
Depreciation
Supplies
Rent Insurance
Total Expense:
Net Income/Loss:
Directions: Build an income statement using the steps provided below.
1) The book store received $50,000 in book sales for 2018, with a 20% increase in revenue each year.
2) Jack's book store received $15,000 each year in ticket sales to book signing events.
3) Find the Total Revenue each year for 2018-2020 using cell referencing.
4) Jack's book store paid $16,000 in employee salaries in 2018. Each year his employee salary cost increased by 25%.
*5) Jack purchased store furniture for $25,000 that is expected to be used over the next 5 years.
6) Jack bought $3,000 in supplies in 2018 and supplies costing $1,000 were used up each year.
'7) Jack signed a contract to pay $800/month for rent between 2018-2020.
8) Jack's book store pays $500 each month to cover insurance.
9) Find the Total Expense each year for 2018-2020 using the SUM function.
10) Find the Net Income/Loss using cell referencing.

Answers: 2

Show answers

Other questions on the subject: Business

Business, 22.06.2019 04:00, callmedarthvadorplz

You are thinking of making your mansion more energy efficient by replacing some of the light bulbs with compact fluorescent bulbs, and insulating part or all of your exterior walls. each compact fluorescent light bulb costs $4 and saves you an average of $2 per year in energy costs, and each square foot of wall insulation costs $1 and saves you an average of $0.20 per year in energy costs.† your mansion has 150 light fittings and 3000 sq ft of uninsulated exterior wall. to impress your friends, you would like to spend as much as possible, but save no more than $750 per year in energy costs (you are proud of your large utility bills). how many compact fluorescent light bulbs and how many square feet of insulation should you purchase? how much will you save in energy costs per year? (if an answer does not exist, enter dne.)

Answers: 1

continue

Business, 22.06.2019 05:50, salvadorperez26

Match the steps for conducting an informational interview with the tasks in each step.

Answers: 1

continue

Business, 22.06.2019 07:40, kanajahbunn

The cutting department of cassel company has the following production and cost data for july. production costs 1. transferred out 12,300 units. beginning work in process $0 2. started 3,900 units that are 60% materials 62,856 complete as to conversion labor 12,622 costs and 100% complete as manufacturing overhead 23,100 to materials at july 31. materials are entered at the beginning of the process. conversion costs are incurred uniformly during the process. determine the equivalent units of production for (1) materials and (2) conversion costs. materials conversion costs total equivalent units of production link to text link to text compute unit costs. (round unit costs to 2 decimal places, e. g. 2.25.) materials $ conversion costs $ link to text link to text prepare a cost reconciliation schedule. (round unit costs to 2 decimal places, e. g. 2.25 and final answers to 0 decimal places, e. g. 1,225.) cost reconciliation costs accounted for transferred out $ work in process, july 31 materials $ conversion costs total costs $

Answers: 1

continue

Business, 22.06.2019 21:40, supasavb99

Western electric has 32,000 shares of common stock outstanding at a price per share of $79 and a rate of return of 13.00 percent. the firm has 7,300 shares of 7.80 percent preferred stock outstanding at a price of $95.00 per share. the preferred stock has a par value of $100. the outstanding debt has a total face value of $404,000 and currently sells for 111 percent of face. the yield to maturity on the debt is 8.08 percent. what is the firm's weighted average cost of capital if the tax rate is 39 percent?

Answers: 2

continue

Do you know the correct answer?

Income Statement Project 2018 2019 2020
Revenue:
Book Sales
Ticket Sales
...