In July of 2012, Taylor purchased 2,000 shares of XYZ common stock for $75,000. He then sold 1,000 shares of XYZ in July of 2013 for $39 per share. The remaining 1,000 shares were finally sold for $47 per share in July 2014. Assuming a MARR of 15%. What was Taylor’s internal rate of return (IRR) on this investment (using the IRR function in Excel for your calculation)?
Please only fill in the number of your calculated result in the blank, e.g., if the result is 7.537%, fill in “7.54”; also keep 2 digits after the decimal point.
Year 0 is July of 2012, Year 1 is July of 2013 and Year 2 is is July of 2014.
IRR is the internal rate of return at which present value of cash flows is equal to initial investment.
initial investment is $75,000. it is a cash outflow that's why it is negative.
Year | Cash flow |
0 | -$75,000 |
1 | $39,000 |
2 | $47,000 |
IRR | 9.32% |
Formulas
In July of 2012, Taylor purchased 2,000 shares of XYZ common stock for $75,000. He then...
You purchased 100 shares of McDonald's Corp. common stock on 04/01/2009 for $57.49 per share. On December 29, 2017 you sold the 100 shares for $172.12 per share. Dividend payment dates and amounts per share for the period of time you owned the stock are shown below. PLEASE SHOW EXCEL FUNCTIONS/FORMULAS (A) Calculate your annual rate of return on this investment. (B) Calculate your annual rate of return without including the dividends in the calculation. You will need to use...
XYZ Company had 200,000 shares of common stock outstanding on December 31, 2017. On July 1, 2018, XYZ issued an additional 45,000 shares for cash. On January 1, 2018, XYZ issued 15,000 shares of convertible preferred stock. The preferred stock had a par value of $100 per share and paid a 5% dividend. Each share of preferred stock is convertible into 8 shares of common. During 2018 XYZ paid the regular annual dividend on the preferred and common stock. Net...
You purchased 258 shares of stock in XYZ Company for $39 per share one year ago. You just sold your shares for $46 per share. You paid a 6% commission on each transaction. What is your rate of return for the year? Express your % answer in decimal format: 4.5% = 0.045
Jan. 1 Purchased 1,000 shares of Escalante Corporation common stock (7%) for $60,800 cash. July 1 Received a cash dividend of $5 per share. Dec. 1 Sold 200 shares of Escalante Corporation common stock for $12,800 cash. Dec. 31 Received a cash dividend of $5 per share. Journalize the transactions.
1 An investor bought 3 shares of stock A in 2010 aer ex-dividend dae activly traded a stock during 2010-2013 She purchased 2 more shares in 2011, sold 1 share in 2012 and then sold all her holding in The stock paid $2 dividend per shane at the end of each year 2013 ater exdiv date 3 1. Flin the the blanks cun shares entted to dividends CF for buying selling siock CF trom dvidends investors net cash ow new...
Year 1 Jan. 2 Purchased 75,000 shares of Grecco Co. common stock for $531,000 cash. Grecco has 300,000 shares of common stock outstanding, and its activities will be significantly influenced by Kodax. Sept. 1 Grecco declared and paid a cash dividend of $1.70 per share. Dec. 31 Grecco announced that net income for the year is $504,900. Year 2 June 1 Grecco declared and paid a cash dividend of $3.40 per share. Dec. 31 Grecco announced that net income for...
em 2. On January 1, 2012, Kristen Corporation had the following stockholders' equity accounts. Common Stock ($20 par value, 60,000 shares issued and outstanding) $1,200,000 Paid-in Capital in Excess of Par-Common Stock 200,000 Retained Earnings 600,000 During the year, the following transactions occurred. Feb. 1 Declared a $1 cash dividend per share to stockbolders of record on February 15, pay. able March 1. Mar. 1 Paid the dividend declared in February. Apr. 1 Announced a 2-for-1 stock split. Prior to...
Jenney Company had these transactions pertaining to stock investments: Feb. 1 Purchased 2,000 shares of Moure Company (10%) for $75,000 cash. June 1 Received cash dividends of $2 per share on Moure stock. Oct. 1 Sold 1,200 shares of Moure stock for $62,400. The entry to record the purchase of the Moure stock would include a a. debit to Stock Investments for $45,900. b. credit to Cash for $55,900. c. debit to Stock Investments for $75,000. d. debit to Investment...
On December 31, 2017, Berclair Inc. had 220 million shares of common stock and 4 million shares of 9%, $100 par value cumulative preferred stock issued and outstanding. On March 1, 2018, Berclair purchased 24 million shares of its common stock as treasury stock. Berclair issued a 5% common stock dividend on July 1, 2018. Four million treasury shares were sold on October 1. Net income for the year ended December 31, 2018, was $110 million. The income tax rate...
On December 31, 2017, Berclair Inc. had 540 million shares of common stock and 4 million shares of 9%, $100 par value cumulative preferred stock issued and outstanding. On March 1, 2018, Berclair purchased 24 million shares of its common stock as treasury stock. Berclair issued a 5% common stock dividend on July 1, 2018. Four million treasury shares were sold on October 1. Net income for the year ended December 31, 2018, was $900 million. The income tax rate...