please answer a and b for a good rating. plesse use excel if possible and show/explaon formulas

use excel and display formulas if possible

2. A computer problem at Mike Owjai Finance has resulfed in incomplete financial statements. Management of the company has asked you to see if you can fill in the missing data. a. Recreate the financial statements as shown using formulas with the ratios given below to fill in the cells with the word "Ratio." Use the Round function to round each of these answers to the nearest $1. b. Complete the financial statements by using formulas that refer to existing data to fill in the remaining cells. 2. A computer problem at Mike Owjai Finance has resulted in incomplete financial statements. Management of the company has asked you to see if you can fill in the missing data. a. Recreate the financial statements as shown using formulas with the ratios given below to fill in the cells with the word "Ratio." Use the RounD function to round each of these answers to the nearest \$1. Recreate the financial statements as shown using formulas with the ratios given below to fill in the cells with the word "Ratio." Use the RounD function to roun Complete the financial statements by using formulas that refer to existing data to fill in the remaining cells