Question: Please help construct a historical income statement, historical balance sheet, and historical statement of cash flow. Please use excel formulas! The years on the trial




Steri Cocp. produces three products in three areasy industrialy pharma, and household. Please use the information from Trial Balance to create the Historical Income Statement, Balance Sheet, and Cash Fasu-low 5ratement for year 2015, 2016, 2017, and 2018. 2 Income Statement 137 26 In bolance \begin{tabular}{|l|l|} 27 & \\ 29 & Revenue \\ 30 & Cost of goods sold \\ 31 & Accounts recelvable Dso \\ 32 & Inventory turnover (COGS) \\ 33 & Prepaid Expenses as a \% of Revenue \\ 34 & Accounts Payable Days of Cogs \\ 35 & Accrued Expenses % of Revenue \\ 36 \end{tabular} 37 CAPX Statistics 9 Prepaid expenses 10 Total Current Assets 12 Fixed Assets - net 13 Total Assets 2 statement of Cach flow Steri Cocp. produces three products in three areasy industrialy pharma, and household. Please use the information from Trial Balance to create the Historical Income Statement, Balance Sheet, and Cash Fasu-low 5ratement for year 2015, 2016, 2017, and 2018. 2 Income Statement 137 26 In bolance \begin{tabular}{|l|l|} 27 & \\ 29 & Revenue \\ 30 & Cost of goods sold \\ 31 & Accounts recelvable Dso \\ 32 & Inventory turnover (COGS) \\ 33 & Prepaid Expenses as a \% of Revenue \\ 34 & Accounts Payable Days of Cogs \\ 35 & Accrued Expenses % of Revenue \\ 36 \end{tabular} 37 CAPX Statistics 9 Prepaid expenses 10 Total Current Assets 12 Fixed Assets - net 13 Total Assets 2 statement of Cach flow
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
