This paper circulates around the core theme of Show excel formula’s/calculations. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Prepare a formal income statement that contains the relevant
subtotals. Show values in whole dollars 1 answer below » Prepare a formal income statement that contains the relevant
subtotals. Show values in whole dollars (no cents). Assume that no
taxes are due on asset purchases or sales. Show excel
formula’s/calculations. View complete question » Beginning of year During Year End of year Cash On Hand $305,500 Quantity Sold 52,500 Quantity Produced 63,000 Sales Price $45.00 Cost per unit to produce $25.40 Staff Expenses $426,400 Facility Expenses $278,200 Asset Sale $1,755,300 Asset Purchase $2,205,000 Tax Prepare a formal income statement that contains the relevant
subtotals. Show values in whole dollars (no cents). Assume that no
taxes are due on asset purchases or sales. Show excel
formula’s/calculations. Beginning of year During Year End of year Cash On Hand $305,500 Quantity Sold 52,500 Quantity Produced 63,000 Sales Price $45.00 Cost per unit to produce $25.40 Staff Expenses $426,400 Facility Expenses $278,200 Asset Sale $1,755,300 Asset Purchase $2,205,000 Tax rate 25% Inventory $75,000 $64,000 Accounts Receivable $47,000 $48,000 Accounts Payable $86,000 $82,000 Depreciation $82,000 Interest Paid on Loan $63,000 Loan Principle payment $152,000 Dividends $108,000 View less » Aug 05 2015 08:10 AM