Retirement Planning – Dividend / Income Generating Assets

Video Tutorial:

*Model updated to reflect a more accurate inflation adjustment.

This financial model will allow the user to enter a wide range of assets they plan on investing in and the annual % yield of those investments. It might be in real estate, bonds, treasuries, S&P, and/or dividend paying stocks.

The model assumes no change in principal and just measures the annual yield against your living expenses over time. Logic has been added to make the timing of various investments dynamic in case you don’t plan on doing everything all at once.

Expense logic is added with start and stop date logic.

The time-line goes on a monthly and annual summary basis for up to 50 years.

Inflation is a variable that can be factored in to show the depletion of the buying power of your assets yield over time. It is also assumed that you are not re-investing any of the income generated from the assets, but you will see the amount of free cash flow after taxes/expenses to see the amount you could re-invest to have no cushion, unless you have included a reserve cushion in the expense schedule.

Visuals of charts are also used to help summarize the information per the assumptions entered by the user.

This is a great way to identify what kind of monthly budget is feasible for you based on some rough income assumptions.

Taxes on an asset-by-asset basis are also included as a variable.

 

Industry ,
Summary See if your income generating assets will be enough to cover your living expenses through retirement.
Screenshots / Pictures









Use Cases , , , , , , , , , , , , ,

Write a Review

Get these templates too for a discount!

Price: $225.00

This is a combined collection of Excel and Google Sheets financial model templates for Accounting and related uses, such as: tracking, inventory management, budget vs. actual, break-even analysis, payment schedule, P&L tracker, etc. The bundle…

Add to wish list
Add to cart Excluding 7.7% tax

Price: $200.00

This is a collection of financial model templates for Real Estate businesses and its related sectors. The models included in this bundle are the following (all Excel models): Joint Venture / WaterFall Real Estate Financial…

Add to wish list
Add to cart Excluding 7.7% tax

Price: $170.00

  This is a bundle of financial model templates for financial plan templates related to Retail Shops. The following are the financial model templates included in this product bundle: Jewelry Store Startup Financial Model Robotic…

Add to wish list
Add to cart Excluding 7.7% tax