please answer and explain

Use the Defined Benefit Excel spreadsheet reviewed in class to answer this question. How much money must the company contribute to its pension fund based on the following information: Pension Fund Account Beginning Balance/Required Balance = $1,000,000 Distribution = $650,000 Investment Earnings Rate - 5% O $600,000 $650,000 O $632,500 O $367.500 Use the Defined Benefit Excel spreadsheet reviewed in class to answer this question. How much money must the company contribute to its pension fund based on the following information: Pension Fund Account Beginning Balance/Required Balance = $1,000,000 Distribution = $650,000 Investment Earnings Rate - 5% O $600,000 $650,000 O $632,500 O $367.500