how much must you donate now if the fund earns interest at a rate of 4% per year? Show your hand calculations and solve this question in excel. Show your cash flows in excel
Q: Assuming no withdrawals or additional payments were made, how much money will be in your retirement…
A: Here we will apply the concept of time value of money. The concept says that value or worth of money…
Q: Compute the 5-month moving average and 7-month moving average of the data below.
A: Moving average is a technique used to analyze data points in a data set. The moving average for one…
Q: Sainsbury is financed by both debt and equity. calculate the weighted average cost of capital (WACC)…
A: To specify:Calculation of weighted average cost of capital
Q: Kinston Industries just announced that it will cut its dividend from $3.00 to $2.00 and use the…
A: Answer - Step 1 - Calculation of Cost of Equity - Stock Price = Dividend / (Cost of Equity -…
Q: Direction: Solve what is being asked and show your complete and neat solution. (ROUND OF PV FACTORS…
A: The annuity amount can be calculated with the help of present value of annuity function
Q: Problem 6. As of the end of 2022, Mindorosas Inc. had total assets of P375,000 and equity of…
A: The process by which a business evaluates possible big projects or investments is known as capital…
Q: Businesspeople need to understand international culture and corporate practices to successfully…
A: Risk mitigation is a strategy to prepare for and mitigate the threats your organization faces. As…
Q: What is the value of this levered firm? EBIT is $750,000 with an unleveredcost of equity of 10%, tax…
A: Earnings before interest and taxes: Earnings before interest, depreciation and taxes are the…
Q: 3b. A company made an additional (incremental) income of $10,000 during the last week of the year.…
A: Tax can be defined as an amount paid to the government on the income. It is a compulsory…
Q: On the basis of the information that John has collected, what estimate can he make of the real rate…
A: Real interest rate (constant dollar interest rate) refers to those interest rate of the company…
Q: Holtzman Clothiers's stock currently sells for $17.00 a share. It just paid a dividend of $2.75 a…
A: i) Stock price after one Year F = P(1+r)n where F= Future value P=present value r=rate of interest…
Q: Maxwell Mining Company's ore reserves are being depleted, so its sales are falling. Also, because…
A: We can use the dividend discount model here. As per the dividend discount mode; the intrinsic value…
Q: Suppose you decide to wait 5 years to save up before buying the house. You are able to put a down…
A: A loan is a type of debt that an individual or other entity incurs. The lender, who is typically a…
Q: b. $ 864
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: An existing factory must be enlarged or replaced to accommodate new production machinery. The…
A: Here, To Find: Rate of return of the building =? More attractive investment =?
Q: How much interest (to the nearest dollar) would be saved on the following loan if the home were…
A: Loan amount = Amount of home * (1-Down payment %) = 501000*(1-20%) =400800
Q: Jarett & Sons' common stock currently trades at $37.00 a share. It is expected to pay an annual…
A: Formula; Cost of common equity = D1 / P0 + g Where; D1 = Next dividend i.e. $1.25 P0 = Current stock…
Q: A process for producing the mosquito repellant Deet has an initial investment of $210,000 with…
A: The Payback period method is a traditional capital budgeting method. It is used to find out the time…
Q: A man borrowed an amount of P150,600 to bank that offers an interest rate of 5.36% compounded…
A: Loan is a borrowed amount of money for a fixed time period, which is expected to be repaid with…
Q: Engr. Richard Flores has P 13, 760 in cash and he would like to invest it in business. His estimates…
A: Initial Investment = P13,760 Salvage Value = P2,000
Q: Why is the rate of Fixed Rate Mortgage higher than Adjustable Rate Mortgage? O Liquidity risk…
A: The difference between Fixed rate mortgage and Adjustable rate mortgages is the interest rate risk…
Q: Derry Corporation is expected to have an EBIT of $3,400,000 next year. Increases in depreciation,…
A: Given, EBIT of Derry Corporation=$3,400,000 next year. Capital spending = $160,000, $155,000, and…
Q: 3. Calculating Dollar Returns You purchased 250 shares of a particular stock at the beginning of the…
A: Return means additional amount received from the invested amount during the investment period. The…
Q: Windhoek Mines, Limited, of Namibia, is contemplating the purchase of equipment to exploit a mineral…
A: The net present value or NPV of any project is a financial measure through which the profitability…
Q: A man is offered two proposals to invest his money. The first offer is to invest $ 20,000 in the…
A: We need to calculate future value of both investments. Higher future value proposal will be chosen…
Q: What is the future value of $10,000 per year for 10 years invested at 10%? $159,374 $138,824…
A: Time value of money (TVM) is used to measure the value of money at different point of time in the…
Q: You deposit $100 in a savings account that earns 6% annual interest compounded monthly. Write a…
A: Future amount is calculated to understand the balance that shall be available for an investor after…
Q: 900 Islands Co. is interested in purchasing a machine that would improve its operational…
A: Given, Cost = $200,000 estimated residual value =$20,000 Useful life = 8 years. Increase in cash…
Q: Sun Instruments expects to issue new stock at $35 a share with estimated flotation costs of 9…
A: Cost of retained earnings = (Expected dividend/Current price) + Growth rate =[(2.5*1.08)/35]+0.08…
Q: Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely…
A: Since you have asked a multiple subpart question, we will answer the first three subparts for you.…
Q: A loan in the amount of $280,000, is contracted over a period of 25 years to finance the purchase of…
A: Here,
Q: What is your prospect about how the Philippine Financial system will evolve in the next 10 years?
A: The financial system is a group of institutions that enable the exchange of funds, such as banks,…
Q: A firm’s current balance sheet is as follows: Assets $ 110 Debt $ 44 Equity $ 66 What is…
A: Note: since fill the blanks options were not provided, the most appropriate ones are used above.…
Q: For an interest rate of 1% per 2 months, determine the number of times interest would be compounded…
A: Compound interest is the interest on interest it can be calculted using below formula:- FV =…
Q: A payday loan provides short-term loans ranging from $250 to $2,000. Assume the cost of the loan is…
A: Short term loan: Short-term loans are borrowed funds used to fulfill immediate liquidity demands,…
Q: How are the unendorsed HO-3 and the HO-5 similar? А. Both are designed to cover condominiums. В.…
A: HO-3 and HO-5 Homeowner insurance policy are insurance policies which gives coverage to a flat or…
Q: A is planning for her retired life. She has 10 more years of service. He would like to deposit 20%…
A: Present value of Annuity Annuity is a series of equal payment at equal interval over a specified…
Q: Compute the net present value of each project, assuming a required rate of 10 percent. If the NPV is…
A: Net Present Value: It is the profitability measure applied in areas of capital budgeting to…
Q: On June 1, 2019, Leni Company acquired a 5-year, 10%, P1,000,000 face value bonds for P920,000. The…
A: Financial instruments can be equity, debt, or derivatives. They can be measured at fair value or…
Q: If you invest $2,538.00 in an account earning an annual interest rate of 3.153% compounded…
A: Interest is the fee paid to investor for investing funds over a period of time. It is the…
Q: A debt of P10,000 with yearly interest of 24% is to be amortized over the next 6 years with the…
A: Debt paid in equal annual payment from year 1 to year 6. Amortization table used to display the…
Q: Two investment opportunities are available, with expected income flows as Table Q4: Table Q4:…
A: Net present value is the difference between Present Value of cash Inflows and Initial Investment. A…
Q: The approach by Borjas (2003) on evaluating the effects on immigration ignores: (a) Cross-wage…
A: Beyond liberalizing the immigration system, an immigration tariff would have a favorable economic…
Q: E.) Is a contractual financial product sold by financial institutions that is designed to accept and…
A: E. The Correct option is 'a. Annuity'.
Q: Assume depreciation is calculated on a straight-line basis for tax purposes. Assume all cash flows…
A: 1a) Net Present Value =Sum of the present value of cash inflows-Present value of cash outflows.…
Q: What is the future value of P4500 per year for 10 years invested at 5%? P56,600 P7,330 P45,000…
A: FORMULA FVA = P*[(1+i)n-1]/i Where FVA - Future value of annuity P - Annual amount i.e. P4500 i -…
Q: D6) it is April 19th. The quoted price of a treasury bond with an actual/365-day count and a 2%…
A: A Bond refers to an instrument that represents the loan being made by the investor to the company…
Q: Which is the correct answer? Use the following table for this question Present value of an Annuity…
A: Net present value is the difference between Present Value of cash Inflows and Initial Investment.…
Q: required retum for Stock X and
A: The required rate of return refers to the minimum amount of profit that an investor will receive…
Q: An unlevered firm has a cost of capital of 11.3 percent and a tax rate of 34 percent. The firm is…
A: We need to calculate weighted average cost of capital(WACC) which will be the firm's levered cost of…
Step by step
Solved in 2 steps with 2 images
- Comprehensive The following are three independent situations: 1. K. Herrmann has decided to set up a scholarship fund for students. She is willing to deposit 5,000 in a trust fund at the end of each year for 10 years. She wants the trust fund to then pay annual scholarships at the end of each year for 30 years. 2. Charles Jordy is planning to save for his retirement. He has decided that he can save 3,000 at the end of each year for the next 10 years, 5,000 at the end of each year for Years 11 through 20, and 10,000 at the end of each year for Years 21 through 30. 3. Patricia Karpas has 200,000 in savings on the day she retires. She intends to spend 2,000 per month traveling around the world for the next 2 years, during which time her savings will earn 18%, compounded monthly. For the next 5 years, she intends to spend 6,000 every 6 months, during which time her savings will earn 12%, compounded semiannually. For the rest of her life expectancy of 15 years, she wants an annuity to cover her living costs. During this period, her savings will earn 10% compounded annually. Assume that all payments occur at the end of each period. Required: 1. In Situation 1, how much will the annual scholarships be if the fund can earn 6%? How much at 10%? 2. In Situation 2, (a) How much will Charles have at the end of 30 years if his savings can earn 10%? How much at 6%? (b) If Charles expects to live for 20 years in retirement, how much can he withdraw from his savings at the end of each year if his savings earn 10%? How much at 6%? (c) How much would Charles need to invest today to have the same amount available at the time he retires as calculated in Situation 2(a) at 10%? How much at 6%? 3. In Situation 3, how much will Patricias annuity be?You plan to set up an endowment at your alma mater that will fund $180,000 of scholarships each year indefinitely. If the principal (the amount you donate) can be invested at 6.4 percent, compounded annually, how much do you need to donate to the university today, so that the first scholarships can be awarded beginning one year from now? (Round answer to 2 decimal places, e.g. 52.75.)You want to endow a scholarship that will pay $12,000 per year forever, starting one year from now. If the school's endowment discount rate is 5%, what amount must you donate to endow the scholarship?
- You want to endow a scholarship that will pay $11,000-per year forever, starting one year from now. If the school's endowment discount rate is 9%, what amount must you donate to endow the scholarship? The amount you must donate is $_______. (Round to the nearest cent.)You want to endow a scholarship that will pay $11,000 per year forever, starting one year from now. If the school's endowment discount rate is 10%, what amount must you donate to endow the scholarship? The amount you must donate is $ (Round to the nearest cent.)You wish to establish a permanent scholarship at Bond University providing a worthy student with $1000 annually. If invested monies generate an 8% return, how much is needed in the scholarship fund?
- You want to endow a scholarship now that will pay $10,000 per year forever, starting the first award 10 years from now. If the school's endowment discount rate is 7 %, what amount must you donate today to endow the scholarship?You want to create an endowment income of $35,000 per year for Oxtordshire Charity, but the Tirst payment will not be made until the 4th year's time. a. If you can earn a return of 8% APR on your investment, and if the payment is made on a monthly basis, calculate how much to invest now? $5,133,086.81 B. $4,133,086.81 $5,233,086.81 $4,233,086.81 $5,250,000.813. A donor wishes to endow a scholarship to a certain university in the name of a certain professor. The scholarship is to provide $50000 per year for the first 8 years and starting 11 years from now $200000 every 3 years (forever). If the university expects to be able to earn a nominal interest of 16% per year compounded continuously on the endowment, how much must the donor give now if the first scholarship is to be given 1 year from now?
- A college wants to provide students with a perpetual scholarship of $10,000 at the end of every 3 months. How large should their endowment fund be if invested at X% (choose the rate) compounded quarterly?Assume you are working with the foundation to fund a scholarship in your name. Currently, the foundation can earn a 5 percent return on any donations. A. How much money would you need to donate to fund a scholarship that pays $25,000 every year forever, starting one year from now? B. How much money would you need to donate if the foundation could increase their return to 7 percent on any donations?(b) As an added benefit to staff, Insignia intends to start a Trust Fund to assist the children of its employees with university tuition via scholarships. The intention of the company is to assist 4 different students annually with a $10,000 grant each. The grant is expected to be increased by 5% annually and provide scholarships indefinitely. Required: i. Assuming this fund will earn 10% interest per annum, calculate the value of the fund today. ii. Insignia decides to fund this amount (calculated in (i)) via monthly deposits over the next 12 months in an enhanced savings account, after which the scholarships will begin. Assuming a return of 12%, compounded monthly, how much would Insignia need to deposit monthly over the next year, to achieve this goal? ii. Compute the effective annual rate on this enhanced savings account.