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

Another question on Business

Business, 22.06.2019 04:50

Harwood company uses a job-order costing system that applies overhead cost to jobs on the basis of machine-hours. the company's predetermined overhead rate of $2.50 per machine-hour was based on a cost formula that estimates $240,000 of total manufacturing overhead for an estimated activity level of 96,000 machine-hours. required: 1. assume that during the year the company works only 91,000 machine-hours and incurs the following costs in the manufacturing overhead and work in process accounts: compute the amount of overhead cost that would be applied to work in process for the year and make the entry in your t-accounts. 2a. compute the amount of underapplied or overapplied overhead for the year and show the balance in your manufacturing overhead t-account. 2b. prepare a journal entry to close the company's underapplied or overapplied overhead to cost of goods sold.

Answers: 1

Answer

Business, 22.06.2019 23:00

Doogan corporation makes a product with the following standard costs: standard quantity or hours standard price or rate direct materials 2.0 grams $ 7.00 per gram direct labor 1.6 hours $ 12.00 per hour variable overhead 1.6 hours $ 6.00 per hour the company produced 5,000 units in january using 10,340 grams of direct material and 2,320 direct labor-hours. during the month, the company purchased 10,910 grams of the direct material at $7.30 per gram. the actual direct labor rate was $12.85 per hour and the actual variable overhead rate was $5.80 per hour. the company applies variable overhead on the basis of direct labor-hours. the direct materials purchases variance is computed when the materials are purchased. the materials quantity variance for january is:

Answers: 1

Answer

Business, 23.06.2019 01:50

Consider a firm with a contract to sell an asset for $149,000 four years from now. the asset costs $85,000 to produce today. a. given a relevant discount rate of 14 percent per year, calculate the profit the firm will make on this asset. (a loss should be indicated by a minus sign. do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. at what rate does the firm just break even?

Answers: 3

Answer

Business, 23.06.2019 02:50

Ll companies has sales of $9,800, net income of $1,060, total assets of $8,950, and total debt of $4,760. assets and costs are proportional to sales. debt and equity are not. a dividend of $371 was paid, and the company wishes to maintain a constant payout ratio. next year's sales are projected to be $10,584. what is the amount of the external financing need?

Answers: 3

Answer

You know the right answer?

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

Questions