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?