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 08:30, dezmondpowell

Which of the following is an example of search costs? a.) driving to a faraway place to find available goods b.) buying goods in some special way that is outside the normal channels c.) paying a premium cost for goods d.) selling extra goods for a discount price

Answers: 1

continue

Business, 22.06.2019 21:40, brianmondesir1owahud

Rebel technology maintains its records using cash-basis accounting. during the year, the company received cash from customers, $43,000, and paid cash for salaries, $23,500. at the beginning of the year, customers owe rebel $1,000. by the end of the year, customers owe $6,600. at the beginning of the year, rebel owes salaries of $5,600. at the end of the year, rebel owes salaries of $3,300. determine cash-basis net income and accrual-basis net income for the year.

Answers: 2

continue

Business, 23.06.2019 00:30, msc1595

Oimpermeable peaeiremblm: a garment you put on when it's raining. eddepnieent: a sales person. rrgteeaa: to negotiate the price of an article. jcaa: a box where the sales person keeps the money of his/her sales. rbatoa: something inexpensive. zalu: the color of the sky. gfolasdaes (3 words): an object that protects your eyes from the sun.

Answers: 2

continue

Business, 23.06.2019 01:30, itscheesycheedar

James jones is the owner of a small retail business operated as a sole proprietorship. during 2017, his business recorded the following items of income and expense: revenue from inventory sales $ 147,000 cost of goods sold 33,500 business license tax 2,400 rent on retail space 42,000 supplies 15,000 wages paid to employees 22,000 payroll taxes 1,700 utilities 3,600 compute taxable income attributable to the sole proprietorship by completing schedule c to be included in james’s 2017 form 1040. compute self-employment tax payable on the earnings of james’s sole proprietorship by completing a 2017 schedule se, form 1040. assume your answers to parts a and b are the same for 2018. further assume that james's business is not a service business, and that it has $155,000 unadjusted basis in tangible depreciable property. calculate james's 2018 section 199a deduction.

Answers: 1

continue

You know the right answer?

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