Carlos purchased 2,000 shares of a common stock last June 2017 for Php 3,200,000. In June 2018, he then sold 1,000 shares of the common stock for Php 1,800 per share. The remaining 1,000 shares were finally sold for Php 2,000 per share in June 2019. What was Carlos's internal rate of return (IRR) on this investment? Use spreadsheet solution.

Carlos purchased 2,000 shares of a common stock last June 2017 for Php 3,200,000. In June 2018, he then sold 1,000 shares of the common stock for Php 1,800 per share. The remaining 1,000 shares were finally sold for Php 2,000 per share in June 2019. What was Carlos's internal rate of return (IRR) on this investment? Use spreadsheet solution.

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 12DQ

See similar textbooks

Similar questions

John began his investing program with a $5,500 initial investment. The table below recaps his returns each year as well as the amounts he added to his investment account. What is his dollar-weighted average return? Time 0 1 2 3 4 A) 1.5 percent B) 2.2 percent C) 2.0 percent D) 1.8 percent E) 2.6 percent Investment $ 5,500 $ 2,000 $ 2,600 $ 3,000 $ 900 Return 8.5 % 5.0 % 4.5% 9.0 % 2.5%
Emma Li is considering investing in two securities, A and B, and the relevant information is given below: State of Economy Probability Return on Security A (%) Return on Security B (%) Bear 0.2 4 1.2 Bull 1-0.2 10 1.2 Suppose Emma borrowed from her friend 99 shares of security B, which is currently sold at $74, and sold all shares of the security. (She promised her friend she would pay her back in a year with the same number of shares of security B). Then she bought security A with the proceeds obtained in the sales of security B shares and the cash of $2,549 she owned. Calculate the standard deviation of her portfolio. Report your answer in decimal form, rounded to 4 decimal points.
jacob has an opportunity to invest in a new retail development in his building. The initial investment is $53,000 and the expected annual cashflows thereafter are {$2,400; $4,000; $4,000; $7,500; $11,000; $11,000; $14,000; $14,000}. What is Jacob's IRR on this investment? (Allow two decimals in the percentage but do not enter the % sign.)
You plan to buy a real estate property. You have $838 to invest and aim to have $2983.16. You plan on investing in a cryptocurrency ETF that you think will have a return of 30.6%. How long until you reach your goal? Include up to 2 decimal places. Answer:
The Total Return on an investment is the relative change in the investment value over a given time period.Total Return=Ending Value−Initial ValueInitial ValueTotal Return=Ending Value-Initial ValueInitial ValueKaty pays $5,500 for shares in a new company. She sells the shares 10 years later for $17,500. What was her total return on this investment? Round your answer to the nearest tenth of a percent.The Total Return on Katy's investment is %
Analyse the following case and answer the questions Five years ago, Anastasia had invested $5,500 into a securities portfolio. Given the rate of return of 12%, how much money Anastasia has in her investment portfolio now? This question is about finding present value or future value? Perform calculation to find out how much money has Anatasia got in her investment portfolio now?
After her first finance class in WBS, Samantha started a Twitter campaign to convince Elon Musk to let her buy one of his shares in SpaceX (which is currently traded privately). She succeeded and managed to buy one share at a price of $169. She expects to sell this share at a price of $250 when she graduates 3 years from now. What is the internal rate of return of this investment? (Calculate it in annual terms and to the closest integer).
Zachary has purchased an investment that he expects to produce income of $3,000 at the end of the first year and $4,000 at the end of the second year. If he pays $5,800 for this investment, what is the internal rate of return?
Engr. Singson wants to get married on June 8, 2023. According to his estimates, he will need P305,000. With this, he started depositing to Landbank on February 8, 2016 with an amount of P10,500. He made a second deposit worth P50,000 on August 24, 2020. How much he deposits on November 4, 2021 so that he will realize the required amount for his weddinf . Use i=6% per year. Consider exact interest.
An individual has $200,000 to invest. They are trying to maximize their return, but have given their investor advisor instruction on how to invest the money. The investment advisor has given them four different alternatives to invest in, they are listed in the table below along with their rates of return that is estimated. Investment-Type Hydro - Stock USA- Treasury Bills The mobile phone Co.-Bonds Texas Oil Co. - Stock Rate of Return 12% 1.25% 3.35% 1.75% The individual has the following parameters. 1. That no more than 50% can be invested in bonds. 2. That at least 25% is invested in treasury bills. 3. That at least 15% be invested in Texas Oil Co. 4. That all of the $200,000 is to be invested. Find the optimal investment mix and what is the project return in the next year?
Waiting period. Jamal is waiting to be a millionaire. He wants to know how long he must wait if a. he invests $22,330.28 at 18% today? b. he invests $45,553.21 at 17% today? c. he invests S148,313.11 at 10% today? d. he invests $343,033.83 at 4% today? a. How long will Jamal have to wait to become a millionaire if he invests $22,330.28 at 18% today? years (Round to the nearest whole number.)
You have a new job as a Financial Planning assistant. Your client wants to invest money in stocks, bonds, and treasuries that have the dividend yields shown in the table below. Your job is to allocate their money across these three investments such that the total dollars of stocks is at least $10,000 more than the total dollars in bonds plus treasuries. In addition, they have identified the maximum investment in each of those three investment types (also shown below). Maximize the dividends earned. Your answer will be the total Dividends earned (rounded to whole dollars). Use Scenario 2 Stocks: yield % Bonds: yield % Treasuries: yield % Stocks: $max Bonds: $max Treasuries: $ max Scenario 1 2.22 2.04 1.93 170,000 60,000 50,000 Scenario 2 1.71 1.98 1.88 400,000 180,000 200,000 Scenario 3 1.14 3.03 2.08 410,000 300,000 300,000 Scenario 4 1.25 1.48 2.55 800,000 750,000 500,000