Need help with this question. Please provide the function and instructions. Thank you!

The Vanderhorst Lane project consist of two investor classes, Class A and Class B. Combined, the two investment classes have a total project amount of $285,000 with Class A totaling $250,000 invested. Following the instructions below, fill in the cells shaded blue (as you enter values in each cell, they will change to white). Vanderhorst Lane Percentage of Class 100% Amount Percentage of Projedt 250,000.00 75,000.00 25,000.00 100,000.00 50,000.00 Class A Investment Total Jason Viem Thomas Zolack Liam Mark Taylor Brite 40% 1. Calculate the amount of the Class B Investment Total and enter into cell C12 Class B Investment Total 100% 2. Calculate the investment amount of Elizabeth Shoemaker and enter in cell c15 IMS Developers, LLC Bo Clarksen Elizabeth Shoemaker 20,000.00 5,000.00 701 75% 3. Enter a formula in D7 that can be used to calculate the class percentage for each investor in Class A. Repeat for Class B investors in cells D13-D15. (hint- use absolute reference) The Class Percentage in cell D6 and D12 should each total 100% Total Project Amount285,000.00 4. Use a formula to calculate the Class A Investment Total as a percentage of the total project amount. Enter this formula in cell E6. Repeat for Class B Investment Total and enter the formula in cell E12. 5. Use a relative formula to calculate each investor's investment percentage of the total project amount. (Cell E13 has the correct value for IMS Developers, LLC as an example)