I Need help with my hoemwork. It is excell worksheet need to create income state

I Need help with my hoemwork. It is excell worksheet need to create income statement. Please, make sure you can do it before offering your bid. Below the questions that needs to be complite. I’ll send you worksheet on which you need to work. (whoever I hire)
Insert an additional Row in the Income Statement between “Salaries” and “Rent.” Call it “Transportation Costs” and value it at $4,000. Under these assumptions the company’s Net Income should have decreased to $28,900. Using this version of the Income Statement as a template, manipulate the entries to calculate Net Income for each of the following questions.
***AFTER EACH QUESTION, KEEP WORKING WITH THE NEW NUMBERS, DO NOT GO BACK TO THE ORIGINAL NUMBERS!***
What would the company’s net income (bottom line) be if:
Taxescouldbereducedto2%?
Thecompanypressuredsuppliersforlowerprices(cost/unit)from$1.50/unitto
$1.30/unit?
Anadvertisingcampaignwascreatedthatraisedtheamountspentonadvertising
from $5,000 to $8,000 but that campaign resulted in sales revenue rising from 20,000
to 30,000 units?
Thecompanymovedandrestructured—movingtoSouthCarolinawhererentisone
third of what it currently is, and offered an incentive program to eliminate a number of highly paid middle managers, which would lower salaries from 20,000 to 13,000?
Lastly, you can use an Income Statement to calculate widely used financial ratios. One of the most popular is Basic Earnings Per Share, which is Net Income divided by the number of shares outstanding.
10
5. Assume that the company has 14,000 shares outstanding. Using the formula Basic Earnings Per Share = Net Income / Number of Share Outstanding calculate EPS.

Posted in Uncategorized

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount