90.2K
Verified Solution
Link Copied!
Determine which of the formulas need to be modified for the spreadsheet to function properly.
Application of the max, min, & sum functions in excel
| Assets | | Financing | |
| Excess cash | 0 =MAX(D12-B12,0) | Revolver | 140 =-MIN(D12-B12,0) |
| Accounts Receivable | 10 | Accounts Payable | 15 |
| Other ST assets* | 75 | Other debt | 160 |
| Long term assets | 425 | Equity | 200 |
| | | | |
| Total assets | 510 | Total financing | 515 |
| | | | |
| Total assets without excess cash | 500 | Total financing without revolver | 360 |
| Assets | | Financing | |
| Excess cash | 0 | Revolver | 140 |
| Accounts Receivable | 10 | Accounts Payable | 15 |
| Other ST assets* | 75 | Other debt | 160 |
| Long term assets | 425 | Equity | 200 |
| | | | |
| Total assets | 510 | Total financing | 515 |
| | | | |
| Total assets without excess cash | 500 | Total financing without revolver | 360 |
Answer & Explanation
Solved by verified expert
