The Nelson Company has $1,312,500 in current assets and $525,000 in cut rent liabilities. Its initial inventory level is $375,000, and it will raise funds as additional notes payable and use them to increase inventory. How much can Nelson's short-term debt (notes payable) increase without pushing is current ratio below 2.0? What will be the firm's quick ratio alter Nelson has - + 2 EI A Read aloud Draw Highlight Erase 282 Part 1 Fundamental Concepts of Corporate Finance 7-9 Current and Quick Ratios raised the maximum amount of short-term funds? AutoSave On Homework Chapter 7 STUDENT) (1) - Protected View D Beezy Beck 28 File Home Insert Draw Page Layout Formulas Data Review View Help & Share Comments O PROTECTED VIEW This file has been verified by Microsoft Defender Advanced Threat Protection and it has't detected any threats. If you need to edit this file click enable editing Enable Editing A1 Problem 7-9 B D G H 1 Problem 7.9 2 3 INPUT 4 Current assets 5 Current liabilities 6 Initial inventory level 7 Addition to notes payable start by entering a value of $100,000 (remember the addition to notes payable also equals the increase in inventa B 9 OUTPUT 10 Current ratio 1. You will need to change the iteration options: click on file options formulas 11 - then increase the maximum iterations and maximum change as noted in the 12 image below. Click on OK to exit options. 13 Quick ratio 2. Create a formula for the current ratio after the inventory increase using all of 14 the input values above. 15 3. Use goal seek to force your calculated value in C10 (set cell) to equal 2.0 (to 16 value) by changing the value in C7 (by changing cell), 17 Problem 7.9 Problem Bablom7012 Si 00 here to search E 209 PM 9/11/2000