Option A (continue renting) offers stable, inflation-protected income and potential appreciation, but managing the property may impact your retirement comfort.

So i have pretty sizable personal assets, along with a relative high income. 

Asking Price 6,795,000 Gross Rent 611,436 Operating Expenses 233,142 Additional Income 35,800 Net Income 414,094Questions- How do I find a multifamily lender who can help me fund this purchase?

Yes, you do get income on the other side, but the prices have bumped up so with interest rates and less inventory to buy, the net income is much less than a few years ago.You can still do it, you just have to factor that in and expect negative cash flow while you live there and then see how good it will be when you leave in a year and do it again.

Quote from @Ashwani Singh: Has anyone got an excel sheet that is good to maintain your month by month rental property management expenses and income?

Through depreciation, particularly accelerated depreciation and bonus depreciation, you can typically offset all rental income such that there is no taxable income from your rental . 

Problem is only "RE pros" get to do it.There are 3 income classifications in the US - Active, Portfolio, and PassiveActive income is income derived from your job, or normal trade or business.Portfolio income is derived from bank instruments - stocks, bonds, etc.Passive income is income earned from investments.Active losses can wipe out both passive and portfolio income, but it doesn't work the other way around.Portfolio (capital) losses are limited to $3,000 annually.Passive losses can only be offset by passive gains.Real estate rental income by its nature is deemed passive per IRC Sec 469One way to get around it is to become a pro - spend more than 750 hours or 1/2 your time in real estate.But most folks aren't real estate pros.

TenantCloud: https://www.tenantcloud.com/Inaggo: https://innago.com/RentRedi: https://rentredi.com/TurboTenant: https:/turbotenant.com/Avail (Realtor.com): https://www.avail.co/Minimum requirements:-Low (<$20/mo) or No Cost-Listing/Syndication-Background Check (Credit, Criminal, Eviction, Income)-Application and Lease with eSign-Automated Payments (prefer an option without fees)-Easy to export financials for tax purposesQuestions:1.

Imagine what our grandparents paid for TVs relative to their income, for a 12" BW box inside a cabinet that weighed 300 pounds, especially in today dollars . .. . 

As for getting a HELOC, it's prime + index (fluctuates based on the market), so to answer your question, if you are able to qualify by yourself, then it's always a better option to get a loan solo, then use your spouse's income as a backup for future investments.