Calcuate the following ratios for financial plamine: Constnact the aro forma financial statements usine the aarameters you calculated. Your pro fomma balance sheet should halance. Select destination and press ENTER or chocse Faste The Moore Compary is preparine its pro forma financial statements for the next year usine this model. The abbevated financial statements are presented below: Sales growth Tax rate 20%21% Calculate each of the parameters mecessary to construxt the pro forma balarke sheet. Construct the pro forma balance sheet. What is the total debt necescary to balance the pro forma halance sheet? _- In this financial plannirg madel, show that it is poasible to solve algebraically far the am aunt af new torowire. vJ Exced Tip tice that the salution to this problem requires the use of eirelar logic. The addition to ratained earnings depends an the net incame, which deperds an the internst rate, which pends on the level of debc, which deperds on the add tion to retained eamings. When you enter the formuas in the spreadsheet, pou will get a "Gircular Reference' efror. However, Select destination and press ENTER or chacse Faste