how to get a summary scenario?

= HomeWork 7 - Excel Sandra Michael SM - O AutoSave of File Home Ou E Insert H Draw Page Layout Formulas Data Review View Developer Help Search Share Comments A La Calibri BIU - -11 - A === S 2 x SE als Wrap Text Merge & Center - . General $ -% . X ! Insert Delete Format Paste . P Conditional Format as Cell Formatting Table Styles Styles ED.00 20 AutoSum : Fill Sort & Find & Clear Filter Select Editing Ideas Clipboard Font Alignment Number Cells Ideas E14 B C D E F H I J K L M N O P Q Feb $ 2 Sales (input) Mar $ 150,000 G Jul $120,000 Apr $ 145,000 May $ 140,000 Jun $ 280,000 170,000 4 Sales (normal) 5 Sales (Good) 6 Sales (Bad) $ $ $ 150,000 150,000 150,000 $ $ $ 145,000 145,000 145,000 $ $ $ 140,000 180,000 110,000 $ $ $ 280,000 $ 330,000 $ 230,000 $ 170,000 $120,000 210,000 $150,000 140,000 $100,000 8 $ 9 Amount to Borrow 10 Loan Repayment 11 72,000 - $ $ - 55,080 $ $ 16,920 Activate Windows Certosa Scenario Summary 1 Scenario Summary 2 Drivers Collection Payments Analysis + @ -- + 100% Type here to search 6:29 PM CO ? 4) ENG 0 5/6/2020 W - HomeWork 7 - Excel Sandra Michael SM - AutoSave Of File Home 2 Insert 0 x Comments Draw Page Layout Formulas Data Review View Developer Help Search Share == = DO > Calibri -11A B I U - 13. A A. Wrap Text Merge & Center - Custom $ % AutoSum- Fill- Clear Paste S E E , 49.90 Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter - Select Font Alignment Number Cells Editing Ideas Clipboard D8 : V f X A =SUM(D4:06) B Feb Mar $ 150,000 $ C D F G H I J K L M N O P QA Apr $ E May $ 280,000 Jul $ 2 Sales 145,000 140,000 $ 170,000 120,000 $ 58,000 4 Customer1-CASH 5 Customer2-40% 6 Customer3-20% $ $ $ 56,000 $ 58,000 $ 30,000 $ 112,000 56,000 29,000 $ $ $ 68,000 112,000 28,000 $ $ $ 48,000 68,000 56,000 7 8 TOTAL COLLECTIONS $ 144,000 $ 197,000 $ 208,000 $ 172,000 Activate Windows Scenario Summary 1 Scenario Summary 2 Drivers Collection Payments Analysis 11 | 0 - + 100% Type here to search o el e A 1 " 5/6/2020 W AutoSave oft W- HomeWork 7 - Excel Sandra Michael SM 5 - 0 X Share Comments Calibri -11AA === > a Wrap Text A General $, 7 AutoSum Fill- Clear Paste BIU, R. -A 5 3 O .00 .00 +0 Insert Delete Format Conditional Format as Cell Formatting Table Styles Merge & Center Ideas Sort & Filter Find & Select Clipboard Font Alignment Number Styles Cells Editing Ideas C6 Fax - A X B Feb $ 150,000 C E G H I J K L M N O P Q R S A Mar $ Apr $ D May 140,000 $ 280,000 Jun $ Jul $ 2 Sales 145,000 170,000 120,000 4 When Bought 5 Vendor is paid $ 105,000.00 $ 210,000.00 $ 105,000.00 $ 127,500.00 $ 90,000.00 $ - $ 210,000.00 $ 127,500.00 $ 90,000.00 $ $ - - Activate Windows Scenario Summary 1 Scenario Summary 2 Drivers Collection Payments Analysis + Type here to search 3 - ACO I 1) ENG 6:29 PM 5/6/2020 100% - W = HomeWork 7 - Excel Sandra Michael SM - O AutoSave of File Home Ou E Insert H Draw Page Layout Formulas Data Review View Developer Help Search Share Comments Calibri -11 A === 2 x als Wrap Text General X ! Paste B I U . . A = Merge & Center, $ % , E 200 P Conditional Format as Cell Formatting Table Styles Styles Insert Delete Format AutoSum A Fill Sort & Find & Clear Filter Select Editing Ideas Clipboard Font Alignment Alignment Number Cells Ideas G13 B C D F G H I J K L M N O P Q Feb $ Mar $ Jul $ 150,000 145,000 E May $ 280,000 $ 197,000 $ 127,500 $ 14,000 Apr $ $ $ $ 120,000 140,000 144,000 210,000 14,000 Jun $ $ $ $ $ 170,000 208,000 90,000 14,000 10,000 2 Sales 3 COLLECTIONS 4 PAYMENTS 5 Monthly Expenses 6 Lease Payment 7 CASH BUDGET 8 Net Monthly Change 9 Beginning Cash Balance 10 Ending Cash Balance(No Borrowing) 11 Minimum Cash Balance 12 Amount to Borrow 13 Loan Repayment 14 Interest Paid 15 Ending Cash Balance(with Borrowing) 16 Cumulative Borrowing $ $ $ $ $ 94,000 40,000 134,000 40,000 (80,000) $ 48,000 $ (32,000) $ 40,000 $ 72,000 $ $ $ 40,000 $ 72,000 $ 55,500 $ 40,000 $ 95,500 $ 40,000 $ - $ 55,080 $ 420 $ 40,000 $ 16,920 $ 16,920 7.00% 99 116,981 $ $ Activate Windows Scenario Summary 1 Scenario Summary2 Drivers Collection Payments Analysis + 0 -- + 100% Type here to search O en 6:29 PM CO ? 4) ENG 0 5/6/2020 W = HomeWork 7 - Excel Sandra Michael SM - O AutoSave of File Home Ou E Insert H Draw Page Layout Formulas Data Review View Developer Help Search Share Comments A La Calibri BIU - -11 - A === S 2 x SE als Wrap Text Merge & Center - . General $ -% . X ! Insert Delete Format Paste . P Conditional Format as Cell Formatting Table Styles Styles ED.00 20 AutoSum : Fill Sort & Find & Clear Filter Select Editing Ideas Clipboard Font Alignment Number Cells Ideas E14 B C D E F H I J K L M N O P Q Feb $ 2 Sales (input) Mar $ 150,000 G Jul $120,000 Apr $ 145,000 May $ 140,000 Jun $ 280,000 170,000 4 Sales (normal) 5 Sales (Good) 6 Sales (Bad) $ $ $ 150,000 150,000 150,000 $ $ $ 145,000 145,000 145,000 $ $ $ 140,000 180,000 110,000 $ $ $ 280,000 $ 330,000 $ 230,000 $ 170,000 $120,000 210,000 $150,000 140,000 $100,000 8 $ 9 Amount to Borrow 10 Loan Repayment 11 72,000 - $ $ - 55,080 $ $ 16,920 Activate Windows Certosa Scenario Summary 1 Scenario Summary 2 Drivers Collection Payments Analysis + @ -- + 100% Type here to search 6:29 PM CO ? 4) ENG 0 5/6/2020 W - HomeWork 7 - Excel Sandra Michael SM - AutoSave Of File Home 2 Insert 0 x Comments Draw Page Layout Formulas Data Review View Developer Help Search Share == = DO > Calibri -11A B I U - 13. A A. Wrap Text Merge & Center - Custom $ % AutoSum- Fill- Clear Paste S E E , 49.90 Insert Delete Format Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter - Select Font Alignment Number Cells Editing Ideas Clipboard D8 : V f X A =SUM(D4:06) B Feb Mar $ 150,000 $ C D F G H I J K L M N O P QA Apr $ E May $ 280,000 Jul $ 2 Sales 145,000 140,000 $ 170,000 120,000 $ 58,000 4 Customer1-CASH 5 Customer2-40% 6 Customer3-20% $ $ $ 56,000 $ 58,000 $ 30,000 $ 112,000 56,000 29,000 $ $ $ 68,000 112,000 28,000 $ $ $ 48,000 68,000 56,000 7 8 TOTAL COLLECTIONS $ 144,000 $ 197,000 $ 208,000 $ 172,000 Activate Windows Scenario Summary 1 Scenario Summary 2 Drivers Collection Payments Analysis 11 | 0 - + 100% Type here to search o el e A 1 " 5/6/2020 W AutoSave oft W- HomeWork 7 - Excel Sandra Michael SM 5 - 0 X Share Comments Calibri -11AA === > a Wrap Text A General $, 7 AutoSum Fill- Clear Paste BIU, R. -A 5 3 O .00 .00 +0 Insert Delete Format Conditional Format as Cell Formatting Table Styles Merge & Center Ideas Sort & Filter Find & Select Clipboard Font Alignment Number Styles Cells Editing Ideas C6 Fax - A X B Feb $ 150,000 C E G H I J K L M N O P Q R S A Mar $ Apr $ D May 140,000 $ 280,000 Jun $ Jul $ 2 Sales 145,000 170,000 120,000 4 When Bought 5 Vendor is paid $ 105,000.00 $ 210,000.00 $ 105,000.00 $ 127,500.00 $ 90,000.00 $ - $ 210,000.00 $ 127,500.00 $ 90,000.00 $ $ - - Activate Windows Scenario Summary 1 Scenario Summary 2 Drivers Collection Payments Analysis + Type here to search 3 - ACO I 1) ENG 6:29 PM 5/6/2020 100% - W = HomeWork 7 - Excel Sandra Michael SM - O AutoSave of File Home Ou E Insert H Draw Page Layout Formulas Data Review View Developer Help Search Share Comments Calibri -11 A === 2 x als Wrap Text General X ! Paste B I U . . A = Merge & Center, $ % , E 200 P Conditional Format as Cell Formatting Table Styles Styles Insert Delete Format AutoSum A Fill Sort & Find & Clear Filter Select Editing Ideas Clipboard Font Alignment Alignment Number Cells Ideas G13 B C D F G H I J K L M N O P Q Feb $ Mar $ Jul $ 150,000 145,000 E May $ 280,000 $ 197,000 $ 127,500 $ 14,000 Apr $ $ $ $ 120,000 140,000 144,000 210,000 14,000 Jun $ $ $ $ $ 170,000 208,000 90,000 14,000 10,000 2 Sales 3 COLLECTIONS 4 PAYMENTS 5 Monthly Expenses 6 Lease Payment 7 CASH BUDGET 8 Net Monthly Change 9 Beginning Cash Balance 10 Ending Cash Balance(No Borrowing) 11 Minimum Cash Balance 12 Amount to Borrow 13 Loan Repayment 14 Interest Paid 15 Ending Cash Balance(with Borrowing) 16 Cumulative Borrowing $ $ $ $ $ 94,000 40,000 134,000 40,000 (80,000) $ 48,000 $ (32,000) $ 40,000 $ 72,000 $ $ $ 40,000 $ 72,000 $ 55,500 $ 40,000 $ 95,500 $ 40,000 $ - $ 55,080 $ 420 $ 40,000 $ 16,920 $ 16,920 7.00% 99 116,981 $ $ Activate Windows Scenario Summary 1 Scenario Summary2 Drivers Collection Payments Analysis + 0 -- + 100% Type here to search O en 6:29 PM CO ? 4) ENG 0 5/6/2020 W