AutoSave . Off H Asset_Valuation_Hwk_1_upload (1) - Compatibility Mode - Excel Shermaine Stuckey SS X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Search Share Comments fx I 2 A Define Name ~ By Trace Precedents fx Show Formulas Calculate Now Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Trig Functions Manager Create from Selection x Remove Arrows Evaluate Formula | Window Calculation Calculate Sheet Options Function Library Defined Names Formula Auditing Calculation C26 X V A B C D E F G H K M N O P Q R S T U MBA 643 Entrepreneurial Finance Homework #1 Financial Mathematics and Valuation The questions below match multiple choice questions online You may use this file to determine the answers, but you submit your all work through the MC answers. Co - 5% 1 The following is a forecast of net cash thrown off from a business. 9 You require a 12% return on your money. What is the maximum price you would pay for this business. 10 11 $550 Each year for the next 5 years. 12 13 14 Purchase Price = 15 16 5% 2 The following is a forecast of net cash thrown off from a business. 17 You require a 15% return on your money. What is the maximum price you would pay for this business. 18 19 Year 2 3 5 6 7 20 Net Cash 21 $ 89 $ 92 $ 110 $ 118 $ 150 $ 165 $ 190 22 Purchase Price = ? 23 24 25 6% 3 What rate of return on you investment would you receive if you paid $425 for the business in #2 above? 26 27 O 28 29 30 6%% 4 Calculate the revenue for each year if the revenue grew at the yearly rate provided. Sheet1 Sheet2 Sheet3 + Edit + 100% O Type here to search W 9 P X 2:48 PM 10/29/2019 E