Only on Excel. You purchased $10,000 worth of Chan’s Midcap Value Fund at $23.5 NAV. The fund is a no load fund. During the past 12 month, the fund distributed $0.45 in dividends and the current NAV is $25.35. What is your return last year? Please show how to solve in excel..
Q: Sure Tea Company has issued 7.4% annual coupon bonds that are now selling at a yield to maturity of…
A: Time to maturity is the time period for which the bond is issued or the amount is financed through…
Q: Issuer Canada quotation reads as follows: a) $1,300 b) $1,080 Coupon 4% c) $1,095 Maturity 1…
A: Bond price:= $1,000×109.50%= $1,095
Q: What is the profitability index for the following set of cash flows if the relevant discount rate is…
A: Capital budgeting is a method of determining the profitability of the project depending upon the…
Q: Opose a stock had an initial price of $74 per share, paid à dividend $1.65 share during the year,…
A: Rate of return is the profit earned above the investment and it is the sum of dividend yield and…
Q: Ron Prentice bought goods from Shelly Katz. On Feb. 26, Shelly gave Ron a time e lay note. On May…
A: Notes are financial instruments in which interest is paid on maturity along with principal amount.
Q: A ten-year security pays cash flows of $1,000 a year at the end of each of the next five years four…
A: The valuation of securities is based on the concept of time value of money. Thus the value of a…
Q: 2014 2018 2019 178 194.3 200.8 a. What is the economy's annual inflation rate for 2019? (Do not…
A: Inflation rate:The inflation rate is an important economic indicator that reflects the erosion of…
Q: How much cushion (in dollars) do you have before you receive a margin call from your broker? That…
A: Let us determine the number of shares you shorted using the formula below:
Q: Which of the following gives the smallest annual interest if 1 year is 365 days? 10.20% APR…
A: The EAR refers to the rate at which an investment earns interest after the effects of compounding…
Q: Select all that are true with respect to the Cost of Capital. Group of answer choices The cost of…
A: The cost of capital represents the return that a company is expected to provide to its investors for…
Q: Wilde Software Development has a 9% unlevered cost of equity. Wilde forecasts the following interest…
A: Tax Shield:A tax shield is a financial strategy that allows companies to reduce their taxable income…
Q: Tiger Woods was paid a $10 million advance to write a book, which took him one year to write.…
A: NPV is the difference between present value of cash flow and initial investment and it should be…
Q: Bond valuation. Estonian company issued 10-year bonds exactly four years ago at a coupon rate of 4%.…
A: Given information,Number of years: yearsCoupon rate: Par value: Yield: Compounding frequency:…
Q: Builtrite is considering purchasing a new machine that would cost $60,000 and the machine would be…
A: The final or the last cash flow of the project which includes the salvage value of the equipment is…
Q: Calculating NAV A fund has a market value of securities of $860 million, cash and receivables of $29…
A: Market Value of Securities = s = $860 millionCash and Receivables = cr = $29 millionCurrent…
Q: 1) Assume you deposited $1,000 in a bank that offered you 10% annual interest rate. If you kept your…
A: Future value of the money is the amount of money that was deposited and amount of compounding…
Q: a company accounts payable manager, which of the following credit terms are most likely to entice…
A: Companies gives cash discount to customers based on the period to motivate customers for early…
Q: If you had the job of deciding to invest $1 million in a US Treasury bond or $1 million in your…
A: US Treasury bond: It is one of the safest investments in the world as it is issued by the US…
Q: If the weakest form of market efficiency holds, then security prices reflect all information found…
A: Technical analysis, which rely on past data to predict future stock price moves, would not be…
Q: question 2,3,4
A: To determine the volume traded we need to look at the sales in the given table. To determine the…
Q: Please calculate the forward rate between the two given spot rates. (ex: if you have a 1y spot and a…
A: The spot rate in year 1 is 3.1%.The spot rate in year 10 is 5.7%.The forward rate to be calculated…
Q: A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a…
A: Here, Expected ReturnStandard DeviationStock Fund17%32%Bond Fund11%23%Risk Free…
Q: How much will Kingston Technologies have to pay each year in 9.00 equal payments, starting 2 years…
A: In the Given case:Since the payments start 2 years from now, we need to calculate the value of loan…
Q: Expenses for a Pizza restaurant include raw material for pizza at $5.00 per slice, $124.00 as…
A:
Q: Your storage firm has been offered $100,000 in one year to store some goods for one year. Assume…
A: NPV refers to net present value. It is an important capital budgeting tool.NPV is the sum of present…
Q: Use the given stock table to find the closing price for ABC Technologies (ABC). 52-Week Div Yld Vol…
A: Stock Table:To get an insight into the performance of the particular stock, one should read the…
Q: Suppose you own an investment that had a total nominal return of 10.7% last year. If the inflation…
A: Variables in the question:Nominal return =10.7%Inflation rate = 3.7%
Q: company with current-year sales of $4,500,000 and cost of goods sold of $3,248,000 reduced its…
A: Cash cycle is the time required to recover cash money from the customer from beginning of…
Q: Suppose you are offered an investment that will allow you to double your money in 9years. You have…
A: Present value is an estimate of the present value of future cash values that may be received at a…
Q: Mary's credit card situation is out of control because she cannot afford to make her monthly…
A: Credit card loans are unsecured loans extended by financial institutions to individuals. These loans…
Q: Ms. T. Potts, the treasurer of Ideal China, has a problem. The company has just ordered a new kiln…
A: A tax shield is a benefit that any individual or corporate entity receives by using deductions that…
Q: McKerley Corporation has preferred stock outstanding that will pay an annual dividend of $3.10 per…
A: Dividend in Year 10 = d10 = $3.10Required Rate of Return = r = 3.48%
Q: What is the maturity of a U.S. Treasury bill with a bond equivalent yield of 8.56 percent and a face…
A: bond equivalent yield = r = 8.56%Face Value = fv = $100,000Price of Treasury bill = p =…
Q: A firm's overall cost of capital is 10% and you are evaluating a project that has the same risk as…
A: WACC, or Weighted Average Cost of Capital, is a financial metric that calculates the average cost of…
Q: Using the FTE approach, find the value of the firm:
A: Calculation of FCF:
Q: 6. Risks of investing in bonds The higher the risk of a security, the higher its expected return…
A: Yield on a bond is proportional to its riskiness. High risk bonds would offer higher yields to the…
Q: Whatever Incorporated, has a bond outstanding with a coupon rate of 534 p as a par value of $1000…
A: Compound = Semiannually = 2Coupon Rate = 5.34 / 2 = 2.67%Yield to Maturity = r = 6.7 / 2 = 3.35%Time…
Q: The duration (in years) of a $1000, 2-year, 5% coupon bond (interest paid annually) is _____ year(s)…
A: Duaration = WherePVC = present value of future cash flows from the bond discounted at market ratePVC…
Q: In 2 years, you will receive $3,000. One year after that, you will receive the first of 8 annual…
A: In the future the value of money will increase due to the accumulation of interest over the period…
Q: A GM and a Ford bond both have 4 years to maturity, a $1,000 par value, a BB rating and pay interest…
A: The yield to maturity is the total return an investor earned by holding the bond until the maturity.…
Q: Avicorp has a $14.5 million debt issue outstanding, with a 5.9% coupon rate. The debt has…
A: a)FV = $1000PMT = 1000*5.9%/2 = $29.5N = 5*2 = 10PV = $1000*95% = $950a) For EAR, Using Financial…
Q: ased on economists' forecasts and analysis, 1-year Treasury bill rates and liquidity premiums for…
A: The liquidity premium theory refers to the fact that the issuing company of a security that does not…
Q: TAFKAP Industries has 3 million shares of stock outstanding selling at $17 per share, and an issue…
A: Calculation of cost of debt:Formula used:
Q: Excel Online Structured Activity: Required annuity payments Your father is 50 years old and will…
A: One need to have planning for the retirment and if done on time will have good happy retirement life…
Q: ABC Company currently has a capital structure consisting of 53% debt and the remaining as equity, a…
A: Old debt = od = 53%Old equity = oe = 1-53% = 47%Levered Beta = lb = 1.7Tax Rate = t = 40%New debt =…
Q: What is WACC (select all that are true)? Group of answer choices Rd (1-Tc) * D/V + Re * E/V Weighted…
A: WACC, or Weighted Average Cost of Capital, is a financial metric that calculates the average cost of…
Q: Use the binomial tree technique to price a one year American call option with strike price $65,…
A: An American call option is a financial contract that gives the holder the right, but not the…
Q: Sea Side, Incorporated, just paid a dividend of $2.20 per share on its stock. The growth rate in…
A: Current Dividend = $2.2Three year discount rate = 19%Next three year discount rate = 14%Growth rate…
Q: 1. You make deposits of $10,000, $6,000, and $5,000 respectively at the end of years 1, 2, and 3 in…
A: How much your savings will be worth in three years=10000*(1+5%)^2+6000*(1+5%)^1+5000*(1+5%)^0=11025…
Q: which currently is 6%. Calculate total fees, both in dollars and as a percent of assets under…
A: Risk and return are essential financial principles. The term “risk” refers to the uncertainty and…
Only on Excel.
You purchased $10,000 worth of Chan’s Midcap Value Fund at $23.5 NAV. The fund is a no load fund. During the past 12 month, the fund distributed $0.45 in dividends and the current NAV is $25.35. What is your return last year?
Please show how to solve in excel..
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
- $1,000 is invested in a fund at the beginning of the year. The fund rate of return is 8% for the first half of the year, and 10% for the second half. You are given the following methods of determining return, given the indicated transactions: Scenario Return Measure Midyear Transaction I Dollar-weighted $500 deposit II Dollar-weighted $500 withdrawal III Time-weighted $500 deposit IV Time-weighted $500 withdrawal Rank the rates of returns under these scenarios. A. I < II = IV < III B. II < III = IV < I C. III < I = II < IV D. IV < I = II < III E. None of these answers is correct.Answer the following question, show all working. Use a financial calculator if needed. DO NOT use excel: Your grandfather left an inheritance for you of $100,000. However you can only drawdown on the investment as follows:Years 1 – 3 $15,000 each yearYear 4 to 6 $10,000 each yearYear 7 $25,000Interest on the fund is 5%.a) What is the present worth of this inheritance?b) Due to high liquidity interest rate have dropped to 4%. What will be the impact on the present worth of this inheritance as a consequence of the market change?Terry has invested $20 000 into a fund with interest at j12 = 18% p.a. What level payment can be withdrawn from the fund at the beginning of each half-year in perpetuity? Answer this question by, first, drawing a cash flow diagram, then writing down the equation of value, and then solving it. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
- The New Fund had average daily assets of $3.9 billion in the past year. If New Fund's expense ratio was 0.80% and the management fee was 0.70%. a. What were the total fees paid to the fund's investment managers during the year? (Enter your answer in millions. Round your answer to 1 decimal place.) Fees paid million b. What were the other administrative expenses? (Enter your answer in millions. Round your answer to 1 decimal place.) Other administrative expenses millionThe New Fund had average daily assets of $2.2 billion in the past year. New Fund's expense ratio was 1.1%, and its management fee was 0.7%. Required: a. What were the total fees paid to the fund's investment managers during the year? (Enter your answer in millions rounded to 1 decimal place.) Total fees paid million b. What were the other administrative expenses? (Enter your answer in millions rounded to 1 decimal place.) Other administrative expenses millionA financial adviser is reviewing one of her client's accounts. The client has been investing $1,000 at the end of every quarter for the past II years in a fund that has averaged 7.3% compounded quarterly. Using a cash flow diagram, how much money does the client have in his account?
- The New Fund had average daily assets of $2.7 billion in the past year. New Fund's expense ratio was 1.6%, and its management fee was 1.4%. * Required: a. What were the total fees paid to the fund's investment managers during the year? (Enter your answer in millions rounded to 2 decimal places.) Total fees paid million b. What were the other administrative expenses? (Enter your answer in millions rounded to 2 decimal places.) Other administrative expenses millionA financial adviser is reviewing one of her client's accounts. The client has been investing $1,000 at the end of every quarter for the past Il years in a fund that has averaged 7.3% compounded quarterly. How much money does the client have in his account? Construct a cash flow diagram and use a formula.Jack Walter recognizes the value of saving part of his income. He has set a goal to have $15,000 in cash available for emergencies. Assume he invests semiannually to have $15,000 in five years and the sinking fund he has selected pays 8% annually, compounded semiannually. Find the total interest earned on the sinking fund using the given table. E Click the icon to view the table. The total interest earned will be S . (Round to the nearest cent as needed.)
- A. Joe is the fund manager. His fund begins with $10 million and has the following monthly returns: Month Net inflows ($ million) HPR (%) Compute the arithmetic average monthly return 1 3 2 4% per month 2% per month 3% per month 1% per month 2 5 8 3 0 (4)NOTE:-I request to you solve correctly and not use excel. Q)A businesswoman needs 55,000 in 10 years. What amount should be deposited in a fund at the end of each quarter at 10% compounded quarterly so that there will be enough money in the fund? Show your computation & cash flow diagram/table correctlyAssume that your uncle starts an account for you in a mutual fund with an initial deposit of $790 today. He also makes $790 deposits at the end of each of year 1 and the end of year 2 (i.e. three deposits in all). After the third deposit, he will make no more contributions . Assuming the fund averages a 7.0% p.a. return , what will the balance in the account be at the end of the 6th year? Record your answer as a dollar amount , rounded to two decimal places , but do not include a dollar sign or any commas in your answer . For example , enter $ 18,232.36987 as 18232.37 .