do it in excel

You have juit sold your hoase for 51,000,000 in cash. Your morteige was coiginally a 30-year mertgage with monthly payments and an initial balance of 5800,000 . The montgye is curmily coactly 18y yein old, and you bive just male a payment. If the intereut nite on the mortenge is 5.25F (APIR), bow much cash will you have from the ale once you pry off the mort gage? Complee she stpu below aring cell reforencer to ghion data or predous calculations, in rome care, a rimple call refermce is all you nund. To eppyparte a formula agrogs a row or down a column, av areat, the dimcrians will speofy the use of that fincrian. Do not Dpe in numerical dats into a cill or funcrion. Jnstoud, make a refermoe to the call in which the data is found Made yovr computarlons only in the Blue orits highlighind below, In all cases, unless othenvise directid, we the nurliet apponatce of ithe data in your formular, wrially the Ginen Data