a. Expand the cash flow budget you created in Problem 12.4 (attached) to include a row for expected cash outflows equal 77% of the current month's sales.

b. Also add a row to calculate the amount of cash that needs to be borrowed in order to maintain a minimum cash balance of $50,000 at the end of each month.

c. Add another row to show the cash inflow from borrowing.

d. Add another row to show the cumulative amount borrowed.

e. Add another row to show the amount of the loan that can be repaid, being sure to maintain a minimum ending balance of $50,000 each month.

f. Add appropriate data validation controls to ensure spreadsheet accuracy.

Kyle Carrier 3/20/2017 Problem 13-6 Initial sales Monthly growth Cash sales Collected following month Collected 2 months later Collected 3 months later Never collected Initial cash balance $ 5,000,000.00 1% 40% 30% 20% 8% 2% $ 350,000.00 Beginning cash balance Sales Cash sales Collections from prior sales Ending cash balance January 350,000 5,000,000 2,000,000 2,350,000 February 2,350,000 5,050,000 2,020,000 1,500,000 5,870,000 March 5,870,000 5,100,500 2,040,200 2,515,000 10,425,200 April 10,425,200 5,151,505 2,060,602 2,940,150 15,425,952 May 15,425,952 5,203,020 2,081,208 2,969,552 20,476,712 June 20,476,712 5,255,050 2,102,020 2,999,247 25,577,979 July 25,577,979 5,307,601 2,123,040 3,029,239 30,730,258 August 30,730,258 5,360,677 2,144,271 3,059,532 35,934,061 September 35,934,061 5,414,284 2,165,714 3,090,127 41,189,902 October 41,189,902 5,468,427 2,187,371 3,121,029 46,498,301 November 46,498,301 5,523,111 2,209,244 3,152,239 51,859,785 December 51,859,785 5,578,342 2,231,337 3,183,761 57,274,883