Loan amortization schedule?

assumptions? first pic.

D Share File Edit View Insert Format Data Tools Help Last edit was made 5 hours ago by Daniel McNally na? 60 $.00 123- Default (Ca 11 BIA 9. - ... - x co Y.. A Mixed Use Project Thu Rawang Hapa OVER BON 0.00 TO TO HERR BE M SD IND IN REDE WON === LON IN UN 12 . LO SI Finanding Assumption Income Tunes Investment Criteria LIV AN Oinary . Valtion Up Angel re WW WW 0 CHAU CA Midwin Media W 4200 Waka was fantas www 10 wwpd Period 0 . 6 10 11 BEFORE TAX CASH ROWS NI Its UN 1 KIE LILAUS HO W 1 . O SI . L. BU LO WR HO LALE LAIN I LL . UL . LI un 2.1 LANS HULL BROKE HEME ELE! LI LIS 0 UHL . LAN LALI WE w 1 www 10 TE 1 LOLLA 11 1 Wer let any Credit MUP Sheet Loan Amortization Schedule Drone NON $ 00 123- Delta- 11 BIG . 53 3- A co-4-4-TS 1 S I. 16 2011 WE 11 ws LANO BE . WLINE Les Vacancy & Cred 1 1 . . - 1 $ 1 1 1 1 1 . 1 WS 1 1 low MWON 1 1 92992299 w NILIM HE He w DERS WIN WT LA HO s 1 URNIUM L. .. LATAN US L. i LUR TI LH . 1. UM w w ALS . B. . 1.1 TOT M DE w w TU LEN un LAP WER -- 1 MLA ww E B IND 1 ME REN LL COM TH OLA 11. LA BULL HUN HATAN TIE ILI ICARE ALTRES Pre Operating in me Amate ED * 3. A Doo 4.41 -T fx Ne tre nome 1 arter ORI KORITY F CS REM $ LI MO w 1 UJU 5 1 1 ES 1 1 NU 3 $ 1 US URANI E. SMS UN WS IN EL 1 UN INS ZUMU 1 TE VARE MIL SIC LAMI 10 AM SUMO 1. OWNER FOLL MER TE 11 TIR UN AIMER Terminal Value IL LIN Period Net Present Value of foretas Cash Flows . 10 2 LULU BLOOM IN TAM WA W LA SERUM Y 1 CA MER . hen M NN AFTER TAX CASH FLOWS GAB name IT INT NAT VA 1 OP M EM UP Sheet - Loan Amortation Schichte + H M RO MUS . 1 1 TE SH SIS GA C 1 4 5 . # THE ILLAS PEN LES ARE WE AS LOS M. AL MO 1 AS LO LANK IN 22 IN TAMSID GLUR EL BIOS MS ARUN LED MIZO LES HELSTU 53 IN LE MESTU 1 EE A KO IN $ 2.1 WW its UE 285 ES T.GO 605 Atar 1 S.O.SI SULIS LL 10 WR urs were acesto 1 WIT an A. SK.KM ST can 1 OS www. w ACE TWIN Se SA, S. $ US 1 $ own to RE 1S RU THE 1 LO SRO 1 LUMIN1 12. ER 14 M. NAS DE 1 UTA LES BTW LUIS net Where LIN, LE LA LA LL Period 10 Present offertex Cash Flow Ah WS Wwwww 1, ISLAN LUNTARI L1 LE AT Mere SM LU LILAR 1 WWI1 WIN LALE 1 Period Net Present Value of Ahar fox Cash Flow 1 5 7 9 10 LA LIS UM wa he SRL BULAR #N 1 NEW HW w 1 1 N www www W UM # 1 NA HUN 11 12 1 7 2 7.21 3 4 S 6 7 8 9 10 74263 7.649089 7.878561 8. 114918 8.358366 8.609117 8.867390 9.133412 R6 File Edit View Insert Format Data Tools Help Last edit was made 5 hours ago by Daniel McNally Share M 1001 - $ 000 123- Cambria 18 BIGA .... BY.X. fx Loan Amortization Schedule A c H 3 1 Loan Amortization Schedule 2 4 5 7 Enter values Loan amount $60,000,000.00 Annual interest rate 6.75 Loan period in years 25 Number of payments per year 12 Start date of loan 1/1/2015 Optional extra payments Scheduled payment Scheduled number of payments Actual number of payments Total early payments Total interest Loen AC NAME NAME ENAME ME 10 11 12 13 Lender name Bradley Financial 16 Pmt. No Payment Date Beginning Balance Scheduled Payment Extra Payment Total Payment Principal Interest Ending Balance Cumulative interest 18 NAME NAME NAME NAME NAME 20 21 27 NAM NAM NAMI ANAMI NAME NAM NAM? ANAM NAM MNAM NAME NAME NAME INAME NAME ANAME NAME NAME NAME ENAMEN NAME NAME NAME NAME NAMED NAME NAME M NAME NAME NAME RAMI NAME NAME NAME NAME NAME NAMI ANAME NAME NAME NAME ANAM NAME M M RAM NAME NAMI NAME NAME NAM NAME NAME 24 25 NAME NAME NAME NAME NAM NAME NAME NAME NAME NAME NAME NAME NAME NAME NAN UNAN NAN INAN NAME NAME UNAMI NAME NAME NAM NAMI NAR INA NAME NAMES NAME NAME NAME WAME 20 29 30 11 INAMI NAME NAME NAME NAME NAME AR NAME NAME NAME FRAME MUP Sheet Loan Amortization Schedule 60% $ 000123 Cambria 18 BISA - - * Mixed Use Project . Mixed Use Project PE, Priles of Real Estate, Fall 2020 Tenen Awumption Rang teme Term Assumption Gros La Ares har Rent Experies Expense Stop Vacancy Credit O.ON Espen Increases 15 mars 8.25 5 $ 5 OMA Office Ome.Ne Retail AS Real Betty Ret - SMS 7.00 $ 7.00 None 7.00 None IN 3 3.ON D.ON 20,000 30.000 30.000 15.000 10,000 1,000 120 1 10 Yan 20 Yan 15 Years 15 Year Anna Annual Anual Invernes 20% Q.ON 3.00 00% 2.0% 4.ON 40% 2.0% $3.00 $36.00 $42.00 $45.00 $40.00 $70.00 $1.500.00 $250,000 OON ON 0 None None None None DON Financing Assumptions Income Taxes Investment Criteria LTV 75.00% 6.79 10 25 Valuation Univerpd NV Une Are Awe Ordinary 2 200 Recapture 25 CRAON Real $ 109,662 CHAMP S 41571 Purchase Price 5 NO,000,000 Ternal Cap Land Value $ 17.000.000 Date Mind Use $65.096.000 Mamily GIM Mund the Land $ 34,019,200 Holding Period Murfamily value 5140100 Cost of Sale Multi Family Land Value $2,900.00 SON 10 DON 60 10 100N A Leveraged NPV Leveraged IRR Accent 0 Period 6 1 2 3 4 BEFORE TAX CASH FLOWS PGI 5 . ODOU 70.000 30,000 10,000 15,000 30,000 1.000 170 1 RAMS 538.00 $35.00 $42.00 $45.00 $40.00 $70.00 51.500 $ 2,660.0005 $ 100.000 5 5 5 S875.000 $ $ 1.200.000 $ 70,000 $ 5 2.460.0005 250 BOOS $ 205,000 5 2.712,200 $ 2,767 4645 1980 c b Do 5 $ 675,000 $ 675.000 $ 1.000 $ 14.40 $ 72.8005 75.712 5 2.146.400 5 2,336,3565 256000 5100.1005 266.00 5 441,012 S 2.622.0035 5 315,000 $ 675,000 5 1,271.450 717405 2425 2015 2015 7.110,0115 287,270 21S $ 126450 S 1,3075345 675,000 $ 1,2919 51.824297 $1.2905 R5.1645 2.526,034 S 2310 2106085 26020 2.000.0115 211425 2.5825 5 14, SO LILI 2,47LHI Les Vacancy & Credit con $ 000 Cambria 18 BIG 4. E- I. 1. V. DY.. X Mond Use Project - Mixed Use Project MEM, Turpm TO WA AN WT ME 1 w SAS n WAT SH 11 1 Financing Assumption Income Valtion TREE we tur Wie S. MS w w! Period 7 8 9 10 IT BEFORE TAX CASHOW . UN . 5 MIRADA . LAN LINUM LAM . www . M. . UR . LES LES UNU TE! W! w LAN IN IN THE LU MUP- Sheet - Loan Amortization Schedule Eb