Calculate loan balance
I'm completing a pro forma for my real estate class in college and i'm stuck on calculating the loan balance section. I assume the relevant information would be a 5% rate, 25 year amortizing loan, DCR of 1.2, 1 point origination fee, a listing price of $10,020,000 and a calculated offer price of $10,154,059.41. I'm very lost so any help would be greatly appreciated thank you!

Edit

My NOI is $512,780 and going in cap rate is 5.05%
[{"id": "eas6lbu", "text": "You need to go see the prof at office hours", "replies": [], "depth": 1}, {"id": "eas91ap", "text": "You also need to know the equity investment", "replies": [], "depth": 1}, {"id": "easamr7", "text": "What is a calculated offer price? You probably also need the noi", "replies": [], "depth": 1}, {"id": "eashb7f", "text": "Yes, you need the noi.  If he gave you a cap rate you could calculate that off the offer price.  With that once your noi is 1.2x your loan payment you can determine you equity requirement.", "replies": [], "depth": 1}, {"id": "easxyrt", "text": "What question is it actually asking you to answer? \n\nLoan balance would just be the purchase price, adding in the cost of the Point, and also take out how much money he put a down payment.\n\nYou dont seem really clear on what question its asking I guess. So he's basically asking you to figure out how much equity the person will have into the deal?", "replies": [], "depth": 1}, {"id": "eat2z4g", "text": "I can tell you your debt yield is 8.4%, but you\u2019ll need NOI to back into your loan (NOI/DY).", "replies": [{"id": "eat56yq", "text": "My NOI is $512,780 so would that make my loan $6,104,523.81? Thank you", "replies": [{"id": "eat8xy6", "text": "Looks right and your LTV is 60%, which is reasonable. ", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "eat63t4", "text": "I can help you out.   If your NOI is $512,780 and you need a DSCR of 1.2, you can calculate your max loan payment by taking (NOI/DSCR).  That gives you a loan payment of $427,316.66.\n\nThen you would calculate your max loan by backing into the present value.  The Excel calculation looks like this:  =PV(0.05/12,25*12,-427316.66/12).  The payments are monthly on a mortgage, that is why you have to divide the interest rate by 12, multiply the 25-year amortization by 12 and divide the payments by 12.  \n\nThat would give you a present value of **$6,091,400.67**.  That is your max loan amount.  \n\nIf you subtract out the origination fee, $60,914.01, you would have $6,030,486.67 of proceeds, which would mean you need $4,123,572.75 of equity.  \n\n\n", "replies": [{"id": "eat7lb5", "text": "Thank you so much!", "replies": [], "depth": 2}, {"id": "eat9cz6", "text": "Only thing missing is other closing costs but can probably ignore for academic purposes. If you want to make a reasonable assumption, go with 5% of purchase price (including origination fee).", "replies": [], "depth": 2}], "depth": 1}]