How should I model a balloon payment on a mortgage

Submitted by gregstewart1952... on Wed, 02/10/2016 - 22:54

Return to Question Forum

Tags:

I'm trying to model a move, including selling my current house and using the proceeds as a balloon payment on a new house mortgage. If I put down a 20% down payment on the Change of Home panel amortized over 15 years, that will get reflected in the housing report. If I increase the the down payment to reflect a balloon payment, the housing report will show a lower mortgage payment, but still over 15 years, whereas in reality a balloon payment will shorten the duration of the mortgage period, but not the contractual monthly payment. Any recommendations on how to make the report reflect the shorter duration as a result of the balloon payment?

Comments

dan royer's picture

dan royer

Thu, 02/11/2016 - 11:28

You'd have to use special

You'd have to use special expenditures with the proper tax consequences--perhaps one set of expenditures for the interest (tax deductible?) and one set for the principal payments. It might end up being a combination of mortgage entered and special expenditures. But you can enter no mortgage and then create the proper payment stream with special expenditures I think.

Log in to post comments

Subscribe to RSS feed

Disclaimer: The suggestions and recommendations provided by Economic Security Planning, Inc.'s software tools and planning services do not constitute financial or investment advice. The creators of Economic Security Planning's software are not certified, registered, authorized, or any other form of financial planners. Economic Security Planning, Inc. is not an investment adviser registered with the U.S. Securities and Exchange Commission or any state securities agency, is not a registered broker-dealer and maintains no other regulatory credentials associated with the management of financial assets. Economic Security Planning, Inc. does not guarantee that the suggestions and recommendations derived from its software tools and planning services will necessarily achieve a secure economic plan. Like any software products, Economic Security Planning, Inc.'s software tools may have errors in its underlying code, and the assumptions about the future that it makes and that users input may prove false. In addition, output from the software tools and planning services may incorporate data obtained from third parties and such data (including any calculations that is based on such data) is provided on an “as is” basis. From time to time the output may contain errors that may be based upon, among other things, human data entry, aggregation and decompilation of data, processing of data through third party calculation engines and other processes that can give rise to errors. The company's financial plans and recommendations, including all of such plans and recommendations provided by its direct planning services, should be viewed as suggestive and informative educational inputs into your financial decision-making. None of our products or services recommend the purchase of specific financial products.

Copyright © 2023, ESPlanner || Patent Number: US 6611807 B1

Design by Zymphonies