Juno Company's controller is negotiating a line of credit for 2018 and collected the following information: Current A Current 2017 (Actual) Q1 2017 138.400 72.300 02 2017 95.000 32400 Q3 2017 69.900 25.200 04 2017 BT.600 8.500 2018 (Forecasted) 01 2018 150,700 79,600 02 2018 105,400 36,000 03 2018 65,200 27,600 04 2018 41,700 9,700 REQUIRED: 1. Calculate the desired level of temporary financing for each quarter of 2018. (Not we are assuming a restrictive maturity matching policy, in which temporary finar funds the entire seasonal increase in NWC beyond the base level) 2. Approximately what limit should Hobson request on its line of credit in 2018? 3. How would an analyst determine if Juno is using temporary financing to fund its long-term assets? Solve 1. Calculate NWC for each quarter. 2. Calculate long term financing for each year thased on lowest NWC financing needs Calculate the difference between minimum (ie. L-T) financing needs for each year. 4. Increase the LT financing needs for each quarter based on annualizing the increase increased needed per quarter Maturity Matching Calculate th morary financing nccd, as the diffracs hetween the foresasted I Regarding the limit itoliodd be a sale faran those the's I neede Pag