Question: Please need help with this question. Please provide instructions Thank you. XYZ Enterprises XYZ Enterprises has a project with a total amount of $6,000,000 They

 Please need help with this question. Please provide instructions Thank you.

Please need help with this question. Please provide instructions Thank you.

XYZ Enterprises XYZ Enterprises has a project with a total amount of $6,000,000 They have raised this amount from 19 investors (16 Class A Investors and 3 Class B Investors). Using the table on the left, follow the instructions below: (Each cell will turn white once a value has been entered) Class A Investors Membership Interes Investment Amount 15% 5% 2% Linn Deskin Doreen Carolina Ute Osborn Patricia Harden Frances Poole Cecila Folmar Brigid Schmoll Tena Lieser Cliff Guid:a Bette Mick Migdalia Carolan Edra Romeo Clelia Reading Katherine Hobgood Tana Mccombs Cornelia Wilkenson 1. Calculate the dollar value of each investor by using a formula The sum should be $6,000,000) A% 2. Total the Class A investor's investment amount and enter in cell G20. Repeat for Class B Investors and enter in G21 9% 1% 3% 10% 5% 5% 7% 9% 5% 3. Using the class investment totals from Step 2, calculate Class A percentage of the total project in cell G23. Repeat for Class B Total Investment Amount of Class A: Total Investment Amount of Class B Class B Investors Ethelene Manriquez Carlotta Mento Kelle Loper 1% 2% 2% Class A Investment Percentage of Total Project Class B Investment Percentage of Total Project Total Project Amount 100% 6,000,000.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!