I only need part C Answered

use the data from part A

part A Data:

I only need part C of the question answered Using the data from part a. PLEASE Show work in EXCEL. thank You

is $920. Utilities average \$288 per month, except in May and June when they average only $173. The ending cash balance in December 2016 was $12,000. a. Create a cash budget for January to June 2017, and determine the firm's ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $10,000. b. Camp and Fevurly are thinking of obtaining a line of credit from their bank. Based on their forecast for the first six months of the year, what is the minimum amount that would be necessary? Round your answer to the next highest $1,000 and ignore interest charges on short-term debt. (Hint: Look up the RoUNDUP function in the online help.) c. Create three scenarios (best case, base case, and worst case) assuming that revenues are 10% better than expected, exactly as expected, or 10% worse than expected. What is the maximum that the firm would need to borrow to maintain its minimum cash balance in all three cases? Use the Scenario Manager and create a summary of your results. Would this change your answer in part b ? is \$920. Utilities average \$288 per month, except in May and June when they average only $173. The ending cash balance in December 2016 was $12,000. a. Create a cash budget for January to June 2017, and determine the firm's ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $10,000. b. Camp and Fevurly are thinking of obtaining a line of credit from their bank. Based on their forecast for the first six months of the year, what is the minimum amount that would be necessary? Round your answer to the next highest $1,000 and ignore interest charges on short-term debt. (Hint: Look up the ROUNDUP function in the online help.) c. Create three scenarios (best case, base case, and worst case) assuming that revenues are 10% better than expected, exactly as expected, or 10% worse than expected. What is the maximum that the firm would need to borrow to maintain its minimum cash balance in all three cases? Use the Scenario Manager and create a summary of your results. Would this change your answer in part b? Aligrimen formating - Toble. syme. Number syle Celio