7. Carlos Primero is a 30-year old employee earning P400,000 per annum. He intends to retire at the age of 40 so that he can engage in his own business. However, he would want to earn a fixed income from a portfolio to maintain his current standard of living. Inflation rate is 4% and investments are expected to realize 8% per annum. How much must be the value of his portfolio at the age of 40? 8. Assuming that the value of Carlos Primero's portfolio at the age of 40 should be P6,000,000, how much should be his target savings goal? 9. Inasmuch as Carlos in No. 7 will be able to live on P150,000 per month upon retirement, what should be the rate of return on the portfolio if he can afford to contribute P100,000 per annum only?
7. Carlos Primero is a 30-year old employee earning P400,000 per annum. He intends to retire at the age of 40 so that he can engage in his own business. However, he would want to earn a fixed income from a portfolio to maintain his current standard of living. Inflation rate is 4% and investments are expected to realize 8% per annum. How much must be the value of his portfolio at the age of 40? 8. Assuming that the value of Carlos Primero's portfolio at the age of 40 should be P6,000,000, how much should be his target savings goal? 9. Inasmuch as Carlos in No. 7 will be able to live on P150,000 per month upon retirement, what should be the rate of return on the portfolio if he can afford to contribute P100,000 per annum only?
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter27: Time Value Of Money (compound)
Section: Chapter Questions
Problem 8E
Related questions
Question
Answer all 3 questions aligned in honor code.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning