1.Assume the total cost of a university education will be P250 000 when your child enters university in 18 years. You presently have P43 000 to invest. What rate of interest must you earn on your investment to cover the cost of your child’s university education?

1.Assume the total cost of a university education will be P250 000 when your child enters university in 18 years. You presently have P43 000 to invest. What rate of interest must you earn on your investment to cover the cost of your child’s university education?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Related questions

Q: You currently have $15,804. You plan on investing it at 20 percent per year until you have $68,555.…

A: Present value refers to the discounted value of all future cash flows including one at maturity.…

Q: The market and Stock J have the following probability distributions: Probability rM rJ 0.3 14 % 18 %…

A: The expected return on a probability distribution is the sum product of probability with the…

Q: A financial institution invests in a zero-coupon bond with a maturity (principal) value of $875,000…

A: Zero coupon bond refers to a bond in which no intermediate interest is distributed in form of coupon…

Q: The earnings per share of a company is 30 and dividend payout ratio is 60%. Multiplier is 2.…

A: According to Graham & Dodd model ,P = M * whereP = price per shareM = MultiplierD = Dividend per…

Q: You need $42.000 need to save today 6.500 dollars 7,500 dollars 8.500 dollar years Eastem bank pays…

A: Amount required (FV) = $42,000Rate of return (r) = 0.072 (or 7.2%)Period (n) = 11 YearsDividend (D)…

Q: How much should a two-earner family have in reserves in case of a job loss? What about a

A: There is a need for money in an emergency in the case of Jobloss and should have sufficient money to…

Q: "Meghan recently inherited $1,420,000, which she immediately invested in an equity index mutual…

A: In this question, we need to solve for r in the formula below:In the formula above, PV = amount…

Q: The payback period method has been criticized for not taking the time value of money into account.…

A: Payback period method:Payback period: This is the most widely used traditional methods of evaluating…

Q: Jack wants to buy a boat today today but has realised that if he takes out a loan he can only repay…

A: Periodic payment, PMT = $500 Interest rate = 12.9% per annum compounded quarterlyPeriod = 10 years…

Q: Second Best Insurance company is advertising a new product to retirees looking to invest their…

A: NPV refers to net present value. It is an important capital budgeting tool. Essentially NPV is the…

Q: An automobile company is going to launch a new car in the coming month whic directly going to impact…

A: When any new product is launched in the market that may succeed or fail in the market and there may…

Q: Assume that the credit risk on a 5 year6 percent annual coupon corporate bond is represented by a…

A: The credit spread is the difference between the yield on a corporate bond and the risk-free…

Q: Lambrook Bank has the following assets and liabilities: • Asset A has a maturity of 5 years and a…

A: The difference between the weighted average maturity of a bank's assets and the weighted average…

Q: turns earned over a given time period are called realized returns. Historical data on realized…

A: Standard deviation is the measure of risk and can be measured as the deviation from the mean return…

Q: Assume that your father is now 50 years old, plans to retire in 10 years, and expects to live for 25…

A: An annuity is a financial product or contract that provides a series of regular payments to an…

Q: 23. Alisha is interested in a specific mutual fund. She has $45,000 to invest now and will be able…

A: A Shares: Alisha can invest $45,000 in A shares and sign a letter of intent to invest an additional…

Q: An investor owns an ETF (Exchange Traded Fund) tracking the ASX 200 index as part of his portfolio,…

A: An Exchange-Traded Fund (ETF) is a type of investment fund that trades on stock exchanges,…

Q: The payback period method has been criticized for not taking the time value of money into account.…

A: Discussion on payback period method:Payback period: It represents the period required to recover the…

Q: An Exchange Traded Fund (ETF) is a security that represents a portfolio of individual stocks.…

A: Here,StockCurrent Market PriceNo. of SharesHPQ$252SHLD$442GE$114

Q: (Capital Asset Pricing Model) Johnson Manufacturing, Inc., is considering several investments. The…

A: Risk Free Rate = rf = 7.5%Market Return = rm = 10.5%

Q: Suppose a sophisticated Eva faces the choice between investment opportunities with monetary payments…

A: Net Present Value (NPV) is a financial metric used to evaluate the profitability of an investment or…

Q: Belgravia Petroleum Inc. is trying to evaluate a generation project with the following cash flows:…

A: Capital Budgeting is the technique for evaluating various projects in terms of profitability of the…

Q: DON'T USE AI, NO SOFTWARE 3. A company wishes to acquire a property with the following payment…

A: The present value refers to the discounted value of all future cash flows at a specified rate of…

Q: The balance on a mortgage was $45,000 and an interest rate of 4.50% compounded semi-annually was…

A: Information Provided:Loan amount = $45,000Interest rate =4.5% compounded semi-annuallyYears = 5

Q: Suppose your expectations regarding the stock market are as follows: State of the Economy Boom…

A: Mean return is the average return. It takes into consideration all probabilities and their…

Q: A child receives $80,930 as a gift which is deposited in a 6% bank account compounded semiannually.…

A: In compounding there is interest on interest including the interest earned on the principle amount…

Q: Insurance company, IHI, is part of a swap agreement with investment bank Lachlin Bank on a notional…

A: Notional amount=100 millionInterest rate=7% semi-annuallyResidual life=18 monthsInterest payment due…

Q: uestion A If you bought a put option contract (contract size is £31,250) with an exercise price…

A: Put option gives the opportunity to sell the currency at the expiration of the contract but there is…

Q: Jason is considering engaging in part-time work as an Uber driver, but he requires an initial…

A: We will use capital budgeting functions in excel here to get the values of NPV and IRR. NPV means…

Q: Claire needs to borrow $6000 to pay for NHL season tickets for her family. She borrows from the…

A: Loans are paid by the monthly payments and these carry the payment for interest and payment for loan…

Q: You are the CFO of a manufacturing company that is considering an investment in new production…

A: Net present value is time value based capital budgeting method and can be found as the difference…

Q: In the above financial statement, the Debt-To-Asset Ratio for 2020 is?

A: The debt to asset ratio is a financial metric that evaluates the proportion of a company's assets…

Q: Net Dollar Retention cannot be lower than logo retention

A: Net Dollar Retention (NDR) and Logo Retention are metrics commonly used to measure the performance…

Q: XYZ Corp sells beach umbrellas. What methodology should it use to account for seasonality? Select…

A: Revenue trajectory method: It is used to evaluate future revenue considering revenue growth rates.…

Q: Net Income and Stockholders' Equity for Four Businesses Four different corporations, Cancer, Libra,…

A: Owner's equity refers to the residual interest in the assets of a business entity after deducting…

Q: ayment of$12,055is due in 2 year,$17,000is due in 4 years, and$8,400is due in 6 years. What single…

A: Present value is the equivalent value today of the future payments based on the time and interest…

Q: What's the present value of $1,025 discounted back 5 years if the appropriate interest rate is 6%,…

A: In a world where the value of money fluctuates over time, investors may use present value as a core…

Q: ABC Corp, a start-up business, is developing its business plan. What must ABC Corp do first? Select…

A: Business Plan is a written document that outlines the goals, strategies, operations and financial…

Q: Question 21: Take two spot-interest curves. One is much steeper than the other as shown in the table…

A: The spot rates are the interest rates for the current period, the period for which is a maximum of a…

Q: Lambrook Bank has the following assets and liabilities: Asset A has a maturity of 4 years and a…

A: A bank has in its books different interest rate sensitive assets and interest rate sensitive…

Q: A recent edition of The Wall Street Journal reported interest rates of 2.85 percent, 3.20 percent,…

A: As per the given information:To determine:Expected one-year rates during Year 6

Q: Using put-call parity formula, derive expressions for the lower bounds for European call and put…

A: Lower Bound of Call and Put Option is as follows:Where,S(0) is Stock priceK is Strike Pricer is risk…

Q: Today is Amy's 24th birthday. Starting today, Any plans to begin saving for her retirement, which…

A: Future value refers to the anticipated value of an investment or asset at a specific point in the…

Q: (Expected rate of return using CAPM) a. Compute the expected rate of return for Intel common stock,…

A: CAPM is a financial model used to determine the expected rate of return on investment, particularly…

Q: Adam current salary is £106000 annually. He expect that his salary will growth 6% every year until…

A: We can determine his salary when he retires using the FV formula as below:Out of the salary at…

Q: You buy an 8 percent, 25 year, 1000 par value floating rate bond in 1999. By the year 2004, rates on…

A: The value of the bond is the present value of all the coupon payments and the present value of the…

Q: (Capital Asset Pricing Model) The expected return for the general market is 13.0 percent, and the…

A: CAPM refers to the model that puts forth the assumption that the systematic risk faced by the stock…

Q: common stock currently outstanding. a. Calculate Everdeen's 2019 earnings per share (EPS). b. If the…

A: Profit before tax = $477,000Tax = 21%Preference dividends = $64,100Shares outstanding =…

Q: Effective date of a decreasing annuity: 1/1/01. Date of first payment: 4/1/01. Frequency of…

A: An annuity refers to a series of periodic payments made in exchange for a lump sum payment. It is…

Q: A firm is considering the following projects. Its opportunity cost of capital is 9%. Cash Flows, $ 2…

A: According to bartleby guidelines , if question involves multiple sub parts , then 1st sub 3 parts…

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Information;

VIEW

Step 2: Calculation of interest rate;

VIEW

Solution

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Assume the total cost of a college education will be $345,000 when your child enters college in 18 years. You presently have $55,000 to invest. What annual rate of interest must you earn on your investment to cover the cost of your child’s college education?
Assume the total cost of a university education will be €290,000 when your child enters college in 18 years. You presently have €40,000 to invest. Required: What annual rate of interest must you earn on your investment to cover the cost of your child’s university education? (Round your answer to 2 decimal places (e.g., 32.16).) Annual rate of interest %
Assume the total cost of a college education will be $350,000 when your child enters college in 15 years. You presently have $67,000 to invest.What annual rate of interest must you earn on your investment to cover the cost of your child’s college education?
Assume the total cost of a college education will be $359,000 when your child enters college in 15 years. You presently have $74,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 enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
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.)
Assume the total cost of a college education will be $245,000 when your child enters college in 15 years. You presently have $108,000 to invest for this purpose. What rate of interest must you earn to cover the cost of your child's college educ?
You estimate a college education will be $300,000 when your child enters college in 18years. You presently have $70,000 to invest. What annual rate of interest must you earn on yourinvestment to cover the cost of your child’s college education?
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 %
You have saved $120,000 for your child to attend college. If it is in an account earning an annual rate of 6%, how much can you take out in equal payments at the end of each of the next four years to pay for their education? Answer: future value = $5,24,953.92Question: How much can you take out in equal payments at the beginning of each of the next four years to pay for their education?
If you put $10,000 into an investment to fund your child's college education in 18 years, how much would you accumulate if you earned 10.24% per year?
Your parents want to invest a lump sum at 8% interest to finance your masters’ degree which you are planning to start in five years’ time. The fees for the masters’ degree are expected to be R331,183.33 at that time. How much do your parents need to invest now?