WA-3- Valuation; Part 1 - Fundamental Method. Use ONLY Excd for this WA, and make sure I can trace ALL your calculations. I can only do this if you did NOT plug in the end answers. If done via Word file, ne points will be given. Here are two problems under this assignment: Problem l. Given the following information, and using the VC method of valuation, determine the % of the company that needs to be given up for $1.5 m investment (10 points total) Required ROR by investors Net income in five years Expected P E ratio in four years 25% $ 3.2 m 12 times Use ONLY Excel for this WA, and make sure I can trace ALL your calculations. I can only do this if you did NOT plug in the end answers. If responses are plugged in or work turned in via a non- Excel file, no points will be given. Here are two problems under this assignment: Grade; 20 Points; Submit vial the related file by 11:59 PM; Sunday, Oct 6 Problem 1. Given the following information, and using the VC method of valuation, determine the % of the company that needs to be given up for $1.5 m investment. (10 points total) Required ROR by investor(s): Net income in five years: Expected P/E ratio in four years: 25% $ 3.2 m 12 times. WA-3- Valuation; Part 1 - Fundamental Method. Use ONLY Excd for this WA, and make sure I can trace ALL your calculations. I can only do this if you did NOT plug in the end answers. If done via Word file, ne points will be given. Here are two problems under this assignment: Problem l. Given the following information, and using the VC method of valuation, determine the % of the company that needs to be given up for $1.5 m investment (10 points total) Required ROR by investors Net income in five years Expected P E ratio in four years 25% $ 3.2 m 12 times Use ONLY Excel for this WA, and make sure I can trace ALL your calculations. I can only do this if you did NOT plug in the end answers. If responses are plugged in or work turned in via a non- Excel file, no points will be given. Here are two problems under this assignment: Grade; 20 Points; Submit vial the related file by 11:59 PM; Sunday, Oct 6 Problem 1. Given the following information, and using the VC method of valuation, determine the % of the company that needs to be given up for $1.5 m investment. (10 points total) Required ROR by investor(s): Net income in five years: Expected P/E ratio in four years: 25% $ 3.2 m 12 times