please post formulas!

please post formulas thank you

D12 4Xfx A B D E 565 566 567 4. A real estate Investor is comparing to debt structures for property acquisition at a price of $5,000,000. Debt 568 structure A b a single, senior mortgage loan with an LTV of 85% at 6% Interest with monthly payments for 15 569 years and 1 discount point. Debt structure B is a combination of two loans: a senior FRM loan with an LTV of 570 60% at 4% Interest with monthly payments over 15 years and 15 points and a second, Junior FRM loan with an 571 LTV of 25% at 9.5% Interest with monthly payments over 15 years. What is the borrower's effective borrowing 572 cost under each of the debt structures assuming all loans are held to their respective maturities. Use the RATE 573 function for debt structure A and the IRR function for debt structure B. Use the IF function to indicate which debt 574 structure the borrower would prefer. 575 576 Debt Structure A 577 Purchase Price 578 LTV 579 Loan Amount Yield 580 Lender's Cash Flow O 581 Interest Rate 582 Maturity in Years Preferred Debt 583 Periods per Year Structure (A or B) 584 Discount Points $85 Senior Lou Payment 586 587 Debt Structure B 588 Purchase Price 589 LTV 590 Loan Amount Yield 591 Lender's Cash Flow 592 Interest Rate 593 Maturity In Years 594 Periods per Year 595 Discount Points 596 Senior Loan Payment + 597 598 Purchase Price 599 LTV 600 Loan Amount 001 Lender's Cash Flow 0 o Interest 0 Marity in Years Periods per Year Concepts Ready M Paste B 1 U aA MI THI $ % O585 x x H C D F G 1 159 567 4. A real estate lovestor is comparing to debe structures for a property acquisition at a price of $5,000,000, 568 Debtreture Alsangle, wnior mortgage loan with an LTV of 85% at 6% Interest with monthly 569 payment for 15 years and 1 discount polet. Debe reture is a combination of two loans a senior FRM 570 loan with as LTV of 60% 4% Interest with monthly payments over 15 years and 1.5 points and send, 571 Junior FRM loan with as LTV of 25% 9.5% Interest with monthly payments over 15 year. What is the 572 borrower's effective borrowing cost under each of the debt structures assuming all loans are held to their 523 respective materice Ust the RATE function for debt structure A and the IRR function for debt structure 574 R. Use the IF function to indicate which debt structure the borrower would prefer. $75 576 Debt Structure A 527 Purchase Price 578 LTV 579 Los Amount Yield 580 Leder Chow 581 Interest Rate $82. Maturity in Year 15 Preferred Debt 583 Periods per year 12 Structure (Aer 39 584 Discount Points 15 Sss Senior Loan Payment $0.00 386 587 Debt Structure S8 Purchase Price SRI LTV 590 Loan Amount Yield 391 Lender Cash Flow 592 Interest Rate 496 S9) Maturity in Years 15 $94Periods per Yes 12 $95 Discount Point 1.30 se Senior Louny 598 Phase Price $99 LTV 231 Lo Amo Lender Flow 602 na 9501 Maturity in Year 15 004 Periode per Yew 12 SOS Los Payment 600 007 Month Chow 597 00 10 611 1 2 4 Concepts + Ready MacBc esc Bo 888 1 F3 0585 x fx A D E G Cash Flow 607 608 609 610 611 612 613 614 615 616 617 1618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 B Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 + 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 Concepts Ready