Please fill in highlight sections!

Also PLEASE include excel formulas used for each answer. All transactions are cash. This is all the information given.

E L M N 0 P Q R S T U V W A B C D F G H 1 K 1 The following horizontal statements model shows the transactions experienced by Red Cat Coffee during Year 1. 2 The tables contains missing data that are highlighted in yellow. Assume all transactions are cash transactions 3 4 Required: 5 Use excel formulas to fill in the missing amounts. 6 Income Statement + 7 8 8 9 10 11 12 13 Assets + Statement of Cash Flows + Rev. 0 Exp. 0 + + - + Net Inc. 0 0 0 + + Stockholders' Equity Com. Stk. + Ret. Earn. 0 0 0 0 0 0 0 Cash 0 400,000 250,000 (200,000) 90,000 (40,000) 0 Balance Sheet Liab. Notes. Pay. 0 0 250.000 0 0 0 0 + + Event Beg. 1 2 3 4 5 6 End + 0 Land 0 0 0 200,000 0 0 0 - + + 0 0 0 NA 400.000 FA 250,000 FA (200,000) LA 90,000 OA (40,000) OA (10,000) FA + + 0 + + = + + 90.000 0 0 0 0 0 = = = (10,000) (40,000) 0 + = + + 0 15 16 17 18 19 20 490,000 + = + + = 21