An engineering student decides to accumulate $500,000 by her sixt pects to start by investing a certain amount, C, on her twenty-third bis the payment by 10 percent each year. She feels she can safely invest compounded. (a) How much should her initial investment, C, be? (b) n for this problem is
Q: 7.11 Determine the rate of return for the following cash flow series. + 0 1 4000 i = ? 12,000 2 3 4…
A: The rate of return (i) is given by the rate at which sum of present value of all cashflows (NPV) is…
Q: Comparing Investment Criteria [LO1, 2, 3, 5, 7] Consider the following two mutually exclusive…
A: Following is the answer to the given question
Q: Calculating IRR LO5] What is the IRR of the following set of cash flows? Year Cash Flow $19,500…
A: IRR is the rate at which the net present value of cash flows is 0. IRR is calculated in 2 steps: 1.…
Q: 2. GM Corp. gives P 38.00 dividend per share for its common stock. The market value of stock is P…
A: Dividend Yield Ratio: The Dividend yield ratio shows you that the what percentage of dividend,…
Q: QZY, Inc. is evaluating new widget machines offered by three companies. The chosen machine will be…
A: To evaluate which machine to choose, we can use the Rate of Return (ROR) analysis. The ROR is the…
Q: 08 Example 4.20: Lottery Valuation 09 Mark Young won the state lottery and will receive the…
A: We can calculate the present value by using the excel formula ''=PV''
Q: 8. Mr. Garcia invested in a Php 1,000 bond for one year with a coupon rate of 7% and was offered at…
A: Bonds are debt instruments issued by companies. The value of a bond (i.e. the amount to be paid…
Q: Calculating Profitability Index [L07] What is the profitability index for the following set of cash…
A: The Profitability index = Present value of future cash inflow / Initial Investment
Q: this year, how many more festivals can be sponsored without raising more money? Think carefully!
A: Present value annuity factor is used to compute the present value of an annuity. Interest is the…
Q: Bond Convexity of the Asset 12.026 Assets 5yr bond bought at a yield of 3.4% $550M (lending money)…
A:
Q: Q1. On March 24, 2014, Brendan and Madison borrow $18,000 each at a simple interest rate r =…
A: There are different methods to calculate simple interest on a loan, and these methods can vary from…
Q: Martha earns $2000 in the first year, and $3000 in the second year. If each of these salaries are…
A: Hi There, Thanks for posting the questions. As per our Q&A guidelines, only one question must…
Q: 1) Four mutually exclusive alternatives are being evaluated, and their costs and revenues are…
A: Internal Rate of Return (IRR) is the rate at which the NPV of project becomes 0. The inflows and…
Q: could you please provide the solution for b and c without using excel?
A: concept. 1. changes in future price = future price of current month - future price of previous…
Q: Find the future value and present value using the ordinary annuity and. No. Principal Rate Mode of…
A: An ordinary annuity is a series of regular payments paid at the end of each period, such as monthly…
Q: Lewis Corporation has two shareholders who are brothers: Ray owns 50% of the stock and Robert owns…
A: Appreciated property dividend - Property is distributed to the shareholder(s) at FMV and gain is…
Q: Given the following three mutually exclusive alternatives, Alternative A •.. B C Initial Cost $50…
A: Let initial cost = C Annual benefits = A n = 5 years i = 10%
Q: Calculating Payback [LO2] An investment project provides cash inflows of $765 per year for eight…
A: Payback period means the total time required to recover the cost of an investment. It is used by…
Q: Semi-annual payments of P500 at the end of each term for 10 years with an interest rate of 5%…
A: Semiannual payment (S) = P 500 n = 10 years = 20 payments r = 5% per annum = 2.5% semiannually
Q: im having trouble with vlookup in excel
A: Type Vlookup in the formula bar of excel sheet.
Q: A company needs 60,000 in five years to buy a new equipment. In order to accumulate this, sum a…
A: Accumulated amount needed = 60000 after 5 years Let the annual payment = A r = 18%
Q: 7. Calculating IRR [LO5] A firm evaluates all of its projects by applying the IRR rule. If the…
A: Using IRR function in Excel
Q: David Davis just received a cash gift from his grandfather. He plans to invest in a five-year bond…
A:
Q: Calculating Payback [LO2] What is the payback period for the following set of cash flows? Year Cash…
A: The payback period refers to one of the capital budgeting techniques. It is defined as the number of…
Q: 16. Problems with Profitability Index [LO1, 7] The Weiland Computer Corporation is trying to choose…
A: Net Present Value (NPV) is excess of PV of inflows over PV of outlays of an proposal whereas…
Q: Problem B: RS Bank pays interest at the rate of 7.6% annually compounded quarterly. How much money…
A: Note: “Since you have posted multiple questions, we will provide the solution only to the first…
Q: Bond valuation and yield to maturity Personal Finance Problem Mark Goldsmith's broker has shown him…
A: Note: We are solving part d and e for you as per your specification and considering the answers of…
Q: * 12. NPV versus IRR [LO1, 5] Mahjong, Inc., has identified the following two mutually exclusive…
A: If two projects are mutually exclusive, the only project with the highest IRR or NPV will be…
Q: What would be the interest rate on a loan of $9476.97 that you paid off with annual payments of…
A: A loan simply refers to the amount borrowed from a lender. The lender in such a scenario might be a…
Q: Calculating NPV and IRR (LO1, 5] A project that provides annual cash flows of $28,500 for nine years…
A: The net present value (NPV) is a capital budgeting method that helps to evaluate a project's…
Q: Mandatory 1: Using the incremental rate of return (AROR) analysis. Determine the best alternative.…
A: Incremental rate of return is a process of analysing financial returns of two or more competitive…
Q: Demand for a product is forecasted for the six periods is 263, 256, 301, 312, 304, and 294…
A: Solution- Given that Six period Forecasted is =263 ,256, 301 ,312 ,304 ,294
Q: How much will be paid every three months for a loan that amounts to P1 400 500.00 if money is worth…
A: Loan Amount = P 1,400,500.00 Time Period = 20 Years Interest Rate = 518%
Q: Calculating Discounted Payback [LO3] An investment project has annual cash inflows of $4,200,…
A: The Discounted Pay Back Period (DPBP) is the period in which a project would return its initial…
please dont solve with excel . solve with p/a f/a.
Step by step
Solved in 3 steps
- Q)A civil engineer planning for her retirement places 11% of her salary each year into a high-technology stock fund. If her salary this year (end of year 1) is $200,000 and she expects her salary to increase by 4% each year, what will be th future worth of her retirement fund after 14 years provided it earns 8% per year? Explain it correctly typed or handwriting. Not solve in excel works.(I need detailed solution and process not excel type of answer)1) Suppose that you want to create a "college fund" for your newborn child and place $300 in a bank account at the end of each of the next 20 years. If that account earns an annual rate of return of 7%, how much will be in that account at the end of the twentieth year? A) $13,420.00 B) $12,977.53 C) $13,178.20 D) $11,828.32 E) $12,298.65
- 1. Abbigail wish to establish a trust fund from which her daughter can withdraw $6,000 every six months for 15 years, when she reach 16 years old. At the end of which time she will receive the remaining money in the trust, which you would like to be $25,000. The trust will be invested at 6% per annum compounded semi-annually. How large should the trust be? 2. Dennis McDonald has just started working with the NCB as a sales representative and is just trying to catch up on having money for retirement. NCB offers him a pension plan with an annuity that is guaranteed to earn 11% interest compounded annually. She plans to work for 12 years before retiring and would then like to be able to draw an income of $110,000 per annum for 16 years. How much must be deposited per annum into his retirement fund to accomplish this? DO NOT USE EXCEL TO ANSWER DO NOT USE EXCEL SHOW ALL WORKINGS1. A civil engineer planning for her retirement places 10% of her salary each year into a high-technology stock fund. If her salary this year (end of year 1) is $160,000 and she expects her salary to increase by 3% each year, what will be the future worth of her retirement fund after 15 years provided it earns 7% per year? 2. A company that manufactures purgable hydrogen sulfide monitors will make deposits such that each one is 7% larger than the preceding one. How large must the first deposit at the end of year I be if the deposits extend through year 10 and the fourth deposit is $5550? Use an interest rate of 10% per year.2. (a) A college student, Amy, decides to fund a retirement account with $2000 per year for 8 years, with the first deposit made one year from today. The rate of return will be 10%. How much will she have in her account when she retires in 40 years? (b) Amy’s friend, Dacio, decides he will start funding his retirement account 8 years from now (first payment in 9 years). He then will invest $2000 each year for 32 years. If his rate of return is 10%, how much will he have when he retires in 40 years?
- Saleh is considering an investment that will pay $5,000 a year for 7 years, starting one year from today. How much should she pay for this investment if she wishes to earn a 12 percent rate of return? a. $17,899.08 b. $18,023.88 c.. $20,186.75 d. $22,818.78Q1) Suppose Rachel Townsley deposits $10,000 into an account that pays 8 percent interest compounded annually.(a) If she withdraws 10 equal annual amounts from the account, with the first withdrawal oocuring 1 year after the deposits, how much can she withdraw each year in order to deplate the fund with the last withdrawal? (b) If first drawal is delayed for 2 years, how much can she withdraw each of the 10 years?2. Ms. Pan Aram has set the goal of accumulating Php 4,000,000 for her son's college fund, which will be needed 18 years in the future. Her investment agent advises her that she can deposit today to Bank X that earns 8% annual interest. a. Option A: How much she needs to deposit today in the bank? b. Option B: If she will be depositing an equal payment of Php 107,000 per year for 18 years at 8% annual interest, how much is the future value? c. Which is the better option Ms. Pan should decide? Why?
- 2. Jack and Jill have just had their first child. If college is expected to costP150,000 per year in 18 years, how much should the couple begin depositing annually at the end of each year to accumulate enough funds to pay the first year's tuition at the beginning of the 19th year? Assume that they can earn a 6% annual rate of return on theirinvestment.4. Assume the total cost of a college education will be $300,000 when your child enters college in 18 years. You presently have $65,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child’s college education? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16)) Annual rate of interest %Assume the total cost of a college education will be $250,000 when your child enters college in 17 years. You presently have $56,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child’s college education? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)