Seved ect FIN Ch. 1-3 Red Cat Coffee has provided an incomplete horizontal statements model for Year 1. The Controller has asked you to help calculate the missing amounts in the incomplete horizontal statements model. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. In the Excel Simulation below, if" E12" is entered in a blank cell, the formula outputs the result from cell E12, which is 400,000 in this example. Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys:+ (plus sign to add).- (minus sign to subtract), (asterisk sign to multiply), and / (forward slash to divide). In the Excel Simulation below, if " E12+E13" is entered in a blank cell, the formula adds the values from those cells and outputs the result, which is 650,000 in this example. If using the other math symbols, the result is an appropriate answer for the function. SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. In the Excel Simulation below, if-SUM(E12, E13, E14)" is entered in a blank cell, the formula outputs the result of adding those three separate cells, which is 450,000 in this example. Similarly, if "-SUM(C11 C13)" is entered in a blank cell, the formula outputs the same result of adding those cells even though they are expressed as a range in the formula, so the result is 450,000 in this example. Al x f. The following horizontal statements model shows the transactions experienced by Red Cat Coffee during Year 1. C D Y G H 1 1 K L M N 0 P Q R S T The following horizontal statements model shows the transactions experienced by Red Car Coffice during Year 1 The tablet contains missing data that are highlighted in yellow. Aene all transactions are cash transactions Required: the excel formadas to fill in the missing amones N Balance Sheet Lisb Tocome Statement 9 Anets . Land Notes Pay Stockholders Equity Com. Stk. 0 Exp. Not Inc. Beg o + 0 1 Cath 0 4000000 150.000 CROTO . 0 . T 0 ER 0 10 . 20 . 0 0 . 0 14 . U 0 + 0 + TA520 ETREKKE . . O 0 . 11 13 11 14 15 14 17 18 19 5 6 TAT . = . W a . . . . 0 0 + + + + . . . . 10 . Ket. Earn 0 0 0 0 0 0 3700 0 0 - - W W . W . 0 0 Statement of NA 400100 FA 25072000 PA CAROLA 90,000 CA (401880) CA 1100005 FA Help Paste Merge & Center Alignment $% Conditional Format as Cell Formatting Table Styles Insert Delete Format Cels Clipboard Font Number G Styles Al X f The following horizontal statements model shows the transactions experienced by Red Cat Coffee during Year 1. D D E G H L M N 0 P Q R 5 ing horizontal statements model shows the transactions experienced by Red Cat Coffee during Year 1 1 contains missing data that are highlighted in yellow, Assame all transactions are cash transactions. 3 4 5 formulas to fill in the missing amounts Income Statement Assets + Balance Sheet Liab, Notes. Pay. Stockholders' Equity Com. Stk. + 10 Event Land Exp. Net Inc. Cash 0 400,000 Rev. 0 Beg + 0 0 0 + 0 A + 0 0 + 6 250,000 + 0 0 + 0 0 (200,000) + 0 0 + 0 + 0 + 90,000 0 (40,000) + 0 + (40000) 0 (10,000) + 0. + + + 11 12 13 14 15 16 17 IN 19 20 21 22 2 3 4 5 6 End BIU. 0 0 0 = . - W . m = = + + + + + + + + + + 10 0 0 Ret. Farn. 0 0 0 0 - . . . W . . = W + Save & Exit FOR- & Clear- T Submit Sort & Filter- Statement Cash Flo NA 400,000 250.000 F (200,000) 90,0000 04 (40,000) C (10,000) F
