Excel format with formulas

APTER Problems a Recreate the income statement and balance Recreate the income wherever possible. Each statement should be on s vepara Try to duplicate the formatting esactly Usingthedau pesmted below: On another worksheet createstatemen of(ih flows for 2016, to not enier any numbers directly on this worksheet. All formulias should be linked directly to the source on previous wokshees b. Using Excels outlining feature, create an outline on the statement of cash flows thai, when collapsed, shows only the subtotals for each section. d. Suppose that sales were $400,000 in 2016 racher than 5369,300 Wha is the 2016 net income and retained earniegs? Undo the changes from pntand change de ree to 35% what e. is the 2016 snet income and retained earmings? Using the data from the previous problem a Create a common-size income statement for 2015 and 2016. This 00% 52100 40,00% 2,100 2. statement should be created on a separate worksheet with all Soemalas linked directly to the income seatement For the Year Faded Deermber 31,2016 b. Create a common-size balance sheet for 2015 and 2016. This tatement should be created on a separate worksheet with all formulas lieked directly to the balance sheet sian, SMA00 41,099$42,100 $104 555 $101440 385,000$352,600 57%,02 $1,200 4HUS $42840 $35,200$32,700 38,050 535,440 otal Liah $190,10 $194,040 52,100$52,100 $121,500$121,500 5 $208,80 APTER Problems a Recreate the income statement and balance Recreate the income wherever possible. Each statement should be on s vepara Try to duplicate the formatting esactly Usingthedau pesmted below: On another worksheet createstatemen of(ih flows for 2016, to not enier any numbers directly on this worksheet. All formulias should be linked directly to the source on previous wokshees b. Using Excels outlining feature, create an outline on the statement of cash flows thai, when collapsed, shows only the subtotals for each section. d. Suppose that sales were $400,000 in 2016 racher than 5369,300 Wha is the 2016 net income and retained earniegs? Undo the changes from pntand change de ree to 35% what e. is the 2016 snet income and retained earmings? Using the data from the previous problem a Create a common-size income statement for 2015 and 2016. This 00% 52100 40,00% 2,100 2. statement should be created on a separate worksheet with all Soemalas linked directly to the income seatement For the Year Faded Deermber 31,2016 b. Create a common-size balance sheet for 2015 and 2016. This tatement should be created on a separate worksheet with all formulas lieked directly to the balance sheet sian, SMA00 41,099$42,100 $104 555 $101440 385,000$352,600 57%,02 $1,200 4HUS $42840 $35,200$32,700 38,050 535,440 otal Liah $190,10 $194,040 52,100$52,100 $121,500$121,500 5 $208,80