fill in all the green and yellow highlighted boxes based on the information provided *with excel formulas please**

heres a clearer picture, thank you

G H F D E Balance Sheet Current Assets Cash $ Marketable Securities $ Aces Receivable $ Promissory Notes S Inventory - raw material, goods in process & finshed goods 8 TTL Current Assets 5,000.00 45,000.00 30,000.00 15,000.00 Income Statement Income Sales Revenue $ 195,000.00 Returns & Allowances $ (8,500.00) Investment Income $ 45,000.00 Net Revenue 20,000.00 6,000,000.00 3,500,000.00 Expenses Directly related to Production Beg Inventory $ 12,000.00 New Purchase $ 194,000.00 Rctums & Allowances (2,200.00) End Inventory s 17,800.00 CGS @ 6.6796 6.6790 + 10,000.00 1,500.00 25,000.00 Unrelated to Production Rent S L'ility S Salaries S Depreciation R&D Expense S Marketing S Oper Expenses 0 Non-Current Assets 1 Plant & Equipment S 2 Bldg & Land $ 13 Depreciation 14 TTL Non-Ourrent Assets 15 16 Miscel Adjustment 17 TTL Assets 18 19 Current Lab 20 Acos Payable S 21 Not Payble S 22 Interest PMT 23 Accruals - aces, interests, taxes S 24 TTL Current Liab 25 26 Non-Current Lab 27 Bond Payble S 28 More S 29 TTL Non-Current Liab 30 31 TIL Liabilities 32 Equity $ 33 Miscel Adjustment 34 TTL Lab & Equity Problem 1 Problom 2 50,000.00 15,000.00 @ 2.50% 36,000.00 4,875.00 2,995.00 2.5096 1.50% Oper Income (EBIT) 2,250,000.00 3,500,000.00 Interest Taxable Income (EBT) Taxes 35.0096 Net Income (EAT or it) 4,000,000.00 Problem 3 Problem 4 + ram B C D E F H 1 Balance Sheet Current Assets 3 Cash $ 4 Marketable Securities $ 5 Accs Receivable $ 6 Promisory Notes $ Inventory - raw material, goods in 7 proces & finhed good $ 8 TTL Current Assets 5,000.00 45,000.00 30,000.00 15,000.00 Income Statement Income Sales Revenue $ 195,000.00 Returns & Allowances $ (3,500.00) Investment Income $ 45,000.00 Net Revenue 20,000.00 $ $ 6,000,000.00 3,500,000.00 @ 6.6796 Expenses Directly related to Production Bag Inventory $ 12,000.00 New Purchase $ 194,000.00 Returns & Allowances S (2,200.00) End Inventory 8 17,800.00 CGS 10 Non-Current Assets 11 Plant & Equipment 12 Bldg & Land 13 Depreciation 14 TTL Non-Current Assets 15 18 Miscel Adjustment 17 TTL Assets 18 19 Current Liab 20 Accs Payable 21 Notes Paybile 22 Interest PMT 23 Accrual, interests, taxes 24 TTL Current Liab 25 26 Non-Current Lab 27 Bonds Paytlc 28 Mortage 29 TTL Non-Current Lab 30 31 TTL Liabilities 32 Exquity 33 Miscel Adjustment 34 TTL Lab & Equity Unrelated to Production Rent S 10,000.00 Utility S 1,500.00 Salaries $ 25,000.00 Depreciation S R&D Expense S 4,875.00 @ Marketing 8 2,995.00 Oper Expenses S S 50,000.00 15,000.00 @ 2.5096 35,000.00 2.50% 1.50% Oper Income (EBIT) S 2,250,000.00 3,500,000.00 8 Interest Taxable Income (EBT) Taxes 85.00% Net Income EAT or it) 4,000,000.00