Mooncy Equipment is putting together its cash budget for the following year and has forecasted expected cash collections over the next five quarters (one year plus the first-quarter of next year). The cash collection estmates are based on sales projections and expected collection of receivables. The seles and cash collection estimates are shown in the following table (in millions of dollars): You also have the following information about Moxiney Equipenent: - You are at the end of the current vear, and Qt is the next penod - In any awen perisd, Mosner's purchases from supplies generally account for 72 of of the mepected sales in the next arpod, and wages, supplies, and taxes are expected to be 15% of the next peraod's sales. - In the thind quartel. Mooney expects to expand one of its plants, which will resuire ar adiditioral $1,072 mullion investmeat. - Every quarter, Mooney poys 545 million in interest and dividend payments to long-term debt and equity investors. You also have the following irformation about Mooney Equipment: - You Bre at the end of the current year, and Q1 is the next period. - In any given period, Mooney's purchaces from supplieis nenerally account for 72 of of the expected sales in the fext period, and wages, sugiblies, arud taxes are expected to be 15% of the next period's sales. - In the third quarter, Mooney expects to expand one of its plants, which will require an additional $1,072 mullion investment. - Every quarter, Mooncy pays 445 million in interest and dividend paynuents to long teim bebt and equity investorsi - Mooney pieleis to keeo a minimum tarpet cash balance of at least $14 million at all times. doltari) Wsing this information, complete the following tabie by making necessary calculations. (Note: Round intemediate calculations to the nearest whale doliary True or False: Based on the surplus or deficit derived from the cash budget, managers nepgatate for what-term lones with banks. They often add a cushion to the difference between forecasted endiey cash balance and the minimsum target cach balance. false True