Ending portfolio value compared with beginning investment

Assignment Help Financial Management

Reference no: EM131087766

A company invests $ 1,000,000 at the brgining of the year. It adds another 250000 at the end of the first quater, withdraws $ 350000 at the end of the second quater adds $ 145000 at the end of the third quater and with draws $ 450000 of the remaining funds at the end of the year. it earns $ 20,000 of interest in the first quater, 17,000 in the second quater, $ 12000 in the third quater and $ 29,000 in the fourth quater.

PLEASE SUBMI THE ANSWER IN EXCEL SPREAD SHEET. CREATE OR WRITE THE FORMULA IN THE SPREAD SHETT AND SHOW YOUR WORK AT ARRIVING AT YOUR SOLUTION

a) What is the annual effective rate earned on the investment portfolio?

b) What rate of return would have been calculated if only looked at the ending portfolio value as compared with the beginning $ 1,000,000 investment?

Reference no: EM131087766

Questions Cloud

What amount of tax refund or tax owed : Cooper is a single dad with 1 child and his TOTAL tax liability for the current tax year is $2,100. His EIC amount is $3,094 and he had no withholdings during the year. What amount of tax refund or tax owed would be on Cooper's tax return?

Depreciation expense can they deduct on schedule : Jeremy and Gladys own a cabin in Sun Valley, Idaho, which they rented for 30 days. They also used the cabin with their family and friends for the ski season for 45 days. Their income and expenses were as follows: rental income $4,000, mortgage intere..

What is the proper tax treatment of these amounts : Hugh and Mary own a cabin in Big Bear that they rented for 45 days at $4,500. They used the cabin for personal use for 30 days during the year. The allocated expenses related to the cabin of $6,000 resulted in a net loss of $1,500 for this rental act..

Spot exchange rate for indian rupees : The spot exchange rate for Indian Rupees is Rs 44/$. The one-year forward exchange rate is Rs 46/$ and the one-year U.S. interest rate is 5%. What is the implied one-year interest rate in India?

Ending portfolio value compared with beginning investment : A company invests $ 1,000,000 at the brgining of the year. It adds another 250000 at the end of the first quater, withdraws $ 350000 at the end of the second quater adds $ 145000 at the end of the third quater and with draws $ 450000 of the remaining..

What is the project discounted payback : Project K costs $45,000, its expected cash inflows are $11,000 per year for 8 years, and its WACC is 8%. What is the project's discounted payback?

Determine the required rate of return for stock : The beta coefficient for 1.63. In addition, 1.835 percent is the current 10 year t-Note rate. Assuming a 5.6 percent equity risk premium, determine the required rate of return for this stock. Using the required rate of return, determine what you thin..

Compute weighted average cost of capital : Speck delivery can buy a piece of equipment that is anticipated to provide an 11% return and can be financed at 6% with debt. Later in the year, the firm turns down an opportunity to buy a new machine that would yield a 9% return but would cost 15% t..

Which dividends are expected to grow at rate : The last dividend paid by Acme, Inc. was $3.00. Acme's growth rate is expected to be 25% percent for three years, after which dividends are expected to grow at a rate of 5 percent forever. The company’s stockholders require a rate of return on equity..

User Account

All Pages