High Growth Fund has a front load of 5% and expected return of 14.5%. Normal Fund has no load. And expected return of 13.8%. Which fund would you hold if you expect to hold the fund for 5 years? How about holding the fund for 10 years? Please show how to solve in excel

Please double check your work !! the answer is not 50.55 or 37.52 % You are considering an investment project with the cash flows of -300 (the initial cash flow), 800 (cash flow at year 1), -200 (cash flow at year 2). Given the discount rate of 10%, compute the Modified Internal Rate of Return (MIRR) using the discountingapproach. 50.55% 19.72% 71.94% 37.52%

Loaded-Up Fund charges a 12b-1 fee of 1% and maintains an expense ratio of 0.70%. Economy Fund charges a front-end load of 2%, but has no 12b-1 fee and has an expense ratio of 0.30%. Assume the rate of return on both funds' portfolios (before any fees) is 6% per year. Required: a. How much will an investment of $100 in each fund grow to after 1 year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Mutual Fund Loaded-Up Fund Economy Fund Investment Values b. How much will an investment of $100 in each fund grow to after 4 years? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Mutual Fund Loaded-Up Fund Economy Fund Investment Values

Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 14.5%. The study period needs to be exactly 8 years and each year should have at least one unique cash flow that is different from the cash flows over the other years. Your answer should contain a table showing the cash flows for each year and a graphical representation of the cash flows (cash-flow diagram).

How much money should be deposited each year for 12 years if you wish to withdraw $309 each year for five years, beginning at the end of the 14th year? Let i=8% per year. Illustrate your solution using CFD.

The value in pounds of a fund at time t = 0 is V0 = 50, 000. After one year (at t = 1) it has increased to V1 = 51, 500 and at that time £1, 500 is withdrawn. After two years (at t = 2) the fund is worth V2 = 50, 800. (a) Compute the time-weighted rate of return. (b) If the fund is liquidated after two years what is the yield that has been achieved?

For the following levered total cash flow returns, what is the levered NPV, and should you pursue the investment if your levered discount rate is 14%? Year Total Cash Flow (Pre-Tax) $ 31,795; yes 31,795; no x-31,795; yes -31,795; no 0 (400,000) $ 1 30,000 $ 2 30,900 $ 3 4 31,827 $ 32,782 $ 5 533,765

Finance

The HUT is evaluating a 5 year investment projected to yield the following relevant cash flows over its 5 year life:   Given that the firm employs a 12% discount rate, what is the value of each of the three criteria: NPV? Profitability Index? Payback Period? V

Your friend offers you an investment opportunity. If you give him $1,200 today, his project will provide you with the following cash flows in Years 1-4: $100, $200, $600, $550. You required 10% return on investments of this risk level. Alternatively, you can invest your $1,200 in the money market fund at 4% today. Which of the two options is a better investment opportunity? Q4. There are two different ways to answers the question (both lead to the same conclusion). Show the complete formula (not the calculator shortcuts) with all the necessary terms that you would use to solve the problem as if you didn't have a financial calculator on hand. Q5. Circle the better investment opportunity: Friend's project / Money market fund