Score: 0 of 2 pts 20 of 25 (10 complete HW Score: 36.33%, 18.16 of 50 pts P14-4 (similar to) Question Help Aggressive versus conservative seasonal funding strategy Dynabase Tool tas forecast is total funding requirements for the coming year as shown in the following table: B a. Dide the firm's monthly funding requirement into (1) a permanent component and (2) a seasonal component, and ind the monthly average for cach of these components. b. Describe the son of long-term and short-term financing sec to meet the local funds requirement under (1) an sgressive funding arsiegand (2) Conservative urcingsriegs. Assumes that under the agressive strategy, long-term Tuncelinarce permanent needs and sport-term funds are used to finance seasonal needs. c. Agurring til short-term funding coels 5% annually and at the cost of long-term funding is 10% annually, use the average found in parlato calculate the total cost each of the strategies described in perlb. Assume that the fim can earn 3% on any excess cash balances d. Discuss the profitability-risk trade-offs associated with the aggressive strategy and these associated with the conservative strategy A. Dide the firm's monthly funding requirement into (1) A permanent component and 2) A PRASONAl component, and find the monthly average for each of these components i Data Table (Cick on the icon here in order to copy the contents of the data table below into a spreadsheet! Month Amount Month Amount January $2,000,000 July $12.000.000 February $2,000,000 August $16.000.000 March $2,000,000 September $11,000,000 Apni $4,000,000 October $8,000 000 May $5,000,000 November $4.000.000 June 38,000,000 December 54.000.000 Print Dona