Loading
Home › Finance Help › business real estate finance project calculations and DCF...
Bidders
ExcellentTutor 9 years ago
Rated 9.09 earned 174531.76 around 5422 assignments.
Hello, am, one of the company's top writers and I am interested in working on your paper. I will ensure the delivery of a high quality paper within the given deadline. I have worked on similar papers in the past and I can assure you of an A grade paper.
$150.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
ticha7 9 years ago
Rated 8.45 earned 3830.23 around 68 assignments.
Hi...am a guru in excel and I will give the best. Thanks
$100.00
  • I will give you the best.
    User_3727 | Sep 20, 2017, 17:59 PM
  • I have worked in excel for years so believe in me.
    User_3727 | Sep 20, 2017, 17:59 PM
  • Do you know how to calculate Real Estates business finance? you must show how and why for the numbers on excel
    User_11637 | Sep 20, 2017, 18:09 PM
  • Yes . please upload the related files.
    User_3727 | Sep 20, 2017, 18:13 PM
  • I will give the best.
    User_3727 | Sep 20, 2017, 18:16 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
TheBest 9 years ago
Rated 9.56 earned 22900.84 around 598 assignments.
Hello dear client; kindly award me this project. I have extensive and wide knowledge in academic writing. My clients are my priority; I ensure high notch piece of work.
$120.00
  • Kindly assign I'll offer you the best
    TheBest | Sep 20, 2017, 18:00 PM
  • are you there?
    TheBest | Sep 20, 2017, 18:00 PM
  • Do you know how to calculate Real Estates business finance? And must show how and why for the numbers
    User_11637 | Sep 20, 2017, 18:05 PM
  • yes trust m with any finance questions
    TheBest | Sep 20, 2017, 18:10 PM
  • alright then. Thank you.
    User_11637 | Sep 20, 2017, 18:12 PM
  • welcome waiting for you to assign thanks
    TheBest | Sep 20, 2017, 18:13 PM
  • I am getting error messages when uploading docs. Can I email it to you instead?
    User_11637 | Sep 20, 2017, 18:19 PM
  • Could you try and see if it upload since the website doesn't allow sharing of mails
    TheBest | Sep 20, 2017, 18:21 PM
  • just did and it's not working.
    User_11637 | Sep 20, 2017, 18:24 PM
  • Is it possible you ask the support team what the issue is?
    TheBest | Sep 20, 2017, 18:25 PM
  • it works.
    User_11637 | Sep 20, 2017, 18:29 PM
  • please show all your works even it's a little math (small numbers). I must know how the numbers arrives. looking forward to your work.
    User_11637 | Sep 20, 2017, 18:29 PM
  • Awesome received the files I'll do my best
    TheBest | Sep 20, 2017, 18:31 PM
  • Thank you.
    User_11637 | Sep 20, 2017, 18:32 PM
  • welcome
    TheBest | Sep 20, 2017, 18:37 PM
  • I got this from my professor about this project....The first step is to write down all the information in the project assignment in an Excel file so you have all information in one place. Then I recommend you start by calculating in Excel which income you receive from each of the three different spaces rented to tenants for 6 years. Please remember that when a lease expires, you assume you rent it out at the then current market rental rate. This means that you also have to forecast the market rental rate for 6 years based on the information given in the project assignment. Once you have the rental income for each of the spaces, you sum them up for each year (i.e. add the income from tenant 1, 2 and 3 for year 1 and so forth) and insert them into the PGI (potential gross income row) in the DCF outline. You then calculate the vacancy and collection losses or V&C based on the information given in the project and complete all the other rows in the pro-forma statement.
    User_11637 | Sep 20, 2017, 21:51 PM
  • hope it helps.
    User_11637 | Sep 20, 2017, 21:52 PM
  • Thanks sorry I was sleeping
    TheBest | Sep 21, 2017, 06:47 AM
  • Hi I have uploaded kindly check and thereafter release the payment. Also, kindly don't forget to leave a good rating/review (10/10). Thanks
    TheBest | Sep 22, 2017, 17:22 PM
  • okay. thanks. Can I look at it this weekend? I am currently not available until Sunday Night.
    User_11637 | Sep 22, 2017, 17:26 PM
  • and in case of any question kindly lem know
    TheBest | Sep 22, 2017, 17:27 PM
  • no problem take your tim
    TheBest | Sep 22, 2017, 17:28 PM
  • time
    TheBest | Sep 22, 2017, 17:28 PM
  • hello, I am a bit behind on my study for my tomorrow exam. I will look at it after my exam tomorrow. sorry for the delay but I want to let you know in advance.
    User_11637 | Sep 24, 2017, 15:11 PM
  • oh okay when you get time just check it so that if there are any corrections I can fix on time thanks
    TheBest | Sep 24, 2017, 15:27 PM
  • hello, thanks for your time. I am looking at the project. can you tell me how did you get this? DCF=CF1/(1+r)^1 + CF2/(1+r)^2 + ….CFn/(1+r)^n or explain it to me, Thanks.
    User_11637 | Sep 26, 2017, 02:15 AM
  • why =G166/(1+0.1)^1 0.1 is 10%? is that number from my instructions?
    User_11637 | Sep 26, 2017, 02:16 AM
  • can you also help understand this? NPV = (C for Period 1 / (1 + R)1) + (C for Period 2 / (1 + R)2) ... (C for Period x / (1 + R)x) - Initial Investment
    User_11637 | Sep 26, 2017, 02:18 AM
  • how did you get the 8,315,703.00 initial investment?
    User_11637 | Sep 26, 2017, 02:20 AM
  • i'm sorry. I mean how did you get this 8,152,650.00 asking price
    User_11637 | Sep 26, 2017, 02:23 AM
  • IRR=CFn/(1+r)^n what is n stand for?
    User_11637 | Sep 26, 2017, 02:26 AM
  • what is FRM stand for?
    User_11637 | Sep 26, 2017, 02:27 AM
  • sorry I was sleeping lem go through the your questions I'll get back
    TheBest | Sep 26, 2017, 05:19 AM
  • hi I've answered your questions and uploaded a file kindly check
    TheBest | Sep 26, 2017, 07:12 AM
  • Good morning! thank you for answering my questions. I submitted the work to my professor and this is his feedback" Looks good, but please use the pro forma and DCF outline I sent around. Once you have calculated the income for each space for each year, you sum it up per year and that is the PGI." I uploading the Pro forma right now. Can you make some changes base on his feedback? other than that, you did a great job!!!
    User_11637 | Sep 26, 2017, 12:59 PM
  • oops so I need to input everything in the pro format outline that you just uploaded? if so mmh would you mind adding a bonus since this wasn't there initially? Also how much time do I've?
    TheBest | Sep 26, 2017, 13:55 PM
  • You did a great job. I will definitely add $30 bonus. I have until Friday.
    User_11637 | Sep 26, 2017, 13:57 PM
  • So 150 total. 120 +30
    User_11637 | Sep 26, 2017, 13:57 PM
  • Awesome!!! on it most probably I'll send before I sleep you are the best
    TheBest | Sep 26, 2017, 14:00 PM
  • hi a minute what about the pro forma outline you only uploaded DCF outline or is it okay that way?
    TheBest | Sep 26, 2017, 14:04 PM
  • I am going to check with my professor. she only send me that...
    User_11637 | Sep 26, 2017, 14:05 PM
  • yes?
    TheBest | Sep 26, 2017, 14:06 PM
  • hi I've just rechecked the instructions "business real estate finance project calculations and DCF" I guess DCF outline is fine thanks
    TheBest | Sep 26, 2017, 14:08 PM
  • oh okay. you are so smart! Thanks.
    User_11637 | Sep 26, 2017, 14:09 PM
  • lol thanks lem work on it
    TheBest | Sep 26, 2017, 14:10 PM
  • this is the response from my professor. "you need to develop the pro-forma statement to do the DCF (NPV and IRR calculations). It’s the same"
    User_11637 | Sep 26, 2017, 15:14 PM
  • cool thanks
    TheBest | Sep 26, 2017, 15:17 PM
  • Hi I'm done kindly add the bonus so that I can upload the file thanks
    TheBest | Sep 26, 2017, 17:49 PM
  • hello
    TheBest | Sep 26, 2017, 19:05 PM
  • hello, I was in class. sorry about that. done.
    User_11637 | Sep 26, 2017, 19:34 PM
  • Can I look at it tomorrow?
    User_11637 | Sep 26, 2017, 19:36 PM
  • Thank you..I've uploaded..after you are done with checking please don't forget to release the payment thanks
    TheBest | Sep 26, 2017, 19:38 PM
  • hello, I am checking your work right now. so I see there are many #######s.. are those suppose to be there?
    User_11637 | Sep 27, 2017, 14:27 PM
  • So how did you get the PGI numbers? V&C numbers? How did you get all those numbers? it's not the same as the original excel? trying to figure it out so that I can explain it to my professor.
    User_11637 | Sep 27, 2017, 14:31 PM
  • sorry I was offline lem check
    TheBest | Sep 27, 2017, 17:58 PM
  • kindly expand the excel cells. All readings are clear. and please don't forget to release the payment...talk later I'm rushing somewhere
    TheBest | Sep 27, 2017, 19:57 PM
  • please read the numbers first. It is all about Excel
    TheBest | Sep 27, 2017, 19:59 PM
  • okay. I will check again tonight. I will release the payment tomorrow afternoon (after my class). can I still message you if i have questions?
    User_11637 | Sep 27, 2017, 20:46 PM
  • Hello, can you tell me how did you get 1416447 (PGI)? where is that number come from? How did you get the sales price (9542582.44)?
    User_11637 | Sep 28, 2017, 12:42 PM
  • how did you get all these numbes? PGI V&C EGI OE NOI DS BTCF Tax ATCF Tax liability NOI Depreciation Interest Taxable income Tax Equity reversion Sales price Selling costs NSP Mortgage balance BTER CGT ATER Year Discounted Cash Flow Analysis (DCF) ATCF ATER Initial equity investment Total CF
    User_11637 | Sep 28, 2017, 12:45 PM
  • I couldn't figure it out since last night.
    User_11637 | Sep 28, 2017, 12:46 PM
  • hello my friend I didn't change anything--whatever is in the excel sheet is the same as what appears in the DCF outline and I can't explain all excel formulas here. Just forward the work to your professor everything is in order. Thank you
    TheBest | Sep 28, 2017, 16:00 PM
  • really? i dont' know why I dont' see it when I was comparing it. Can you at least tell me what row or section at for the PGI amount from the DCF outline? Maybe I will be able to see the rest of it? I even copy the number and paste it to the original DCF outline and I can't find it
    User_11637 | Sep 28, 2017, 16:02 PM
  • FYI... I have class in 5 mins and can't use internet. I will check the messages after 3pm.
    User_11637 | Sep 28, 2017, 16:04 PM
  • Okay I'll look at it again as soon as I get back home
    TheBest | Sep 28, 2017, 16:06 PM
  • No my friend I think you didn't get what I said ..the outline needed just answers so I calculated (using the excel figures and formulae) and I just put the answers in the DCF outline... Otherwise everything is in the excel . I don't know what else to explain coz the formulae to calculate all those things are reading available via online. Hope you understand. I believe i met all the requirement of the assignments. No doubt whatsoever
    TheBest | Sep 28, 2017, 19:56 PM
  • Hello! You did a perfect job. I just didn’t know where those numbers come from. There’s no point of submitting it if I don’t know where those numbers come from. For example, how did you get the numbers for the PGI?
    User_11637 | Sep 28, 2017, 20:02 PM
  • $1416447. How did that number created? I must have all these info of where is it come from. Otherwise, I’m in trouble
    User_11637 | Sep 28, 2017, 20:04 PM
  • All the work must show including all the formulas and excel. With different sheet of paper. So that I understand where those numbers come from
    User_11637 | Sep 28, 2017, 20:05 PM
  • I’m sorry but I have to go now. I’ll check again in 3 hours.
    User_11637 | Sep 28, 2017, 20:06 PM
  • To be honest with you I did the calculations (using the figures in excel) on rough papers. I can't even trace them coz I traveled and I won't be home till Sunday. If it can wait till then that will be good I would explain step by step. Right now I've so much in my mind I can't even concentrate. Please understand but if you truly know the formulas to calculate PGI and the rest I don't think this would be a big issue. Coz the DCF only required that I input the answers
    TheBest | Sep 28, 2017, 20:47 PM
  • I understand. Sunday is fine since it’s important for my grade and I have to show my professor how those numbers appear. There will be points deductions since my assignment will be late but it’s better than 0%
    User_11637 | Sep 28, 2017, 21:36 PM
  • thanks
    TheBest | Sep 29, 2017, 06:58 AM
  • Kindly check the three files that I've just uploaded...I believe I've clarified everything...hope you'll release the payment now so that it can be added in today's payment. thanks
    TheBest | Oct 01, 2017, 18:19 PM
  • okay. thanks. this helps very much. Just quick question. where did you get the PGI numbers? $1416447.00 (year 1), 1474414.28 (YEAR 2)?
    User_11637 | Oct 01, 2017, 18:53 PM
  • at the pro format
    User_11637 | Oct 01, 2017, 18:56 PM
  • I understand the rest of it.
    User_11637 | Oct 01, 2017, 18:56 PM
  • I just input the data (from the excel) and it came automatic from the given online formulas
    TheBest | Oct 01, 2017, 18:56 PM
  • ok. which excel? that's the part that I dont' get.
    User_11637 | Oct 01, 2017, 18:57 PM
  • where is the given online formulas? what would that be?
    User_11637 | Oct 01, 2017, 18:58 PM
  • I know where the V&C number came from. I found that.
    User_11637 | Oct 01, 2017, 18:58 PM
  • did you check the link that I uploaded in word document?
    TheBest | Oct 01, 2017, 18:59 PM
  • this link right? this link only how me how to see the formula and I know how to do that. https://www.ablebits.com/office-addins-blog/2016/01/13/show-formulas-excel/
    User_11637 | Oct 01, 2017, 19:00 PM
  • what i don't understand are where you got PGI from? where is 1416447 came from? there aren't formula. I tried to compared it to the original excel but I can't find that numbers
    User_11637 | Oct 01, 2017, 19:01 PM
  • is there like a several numbers add up to become 1416447.00?
    User_11637 | Oct 01, 2017, 19:02 PM
  • just so you know.. i'm adding another $50 for you. for your time. Thanks.
    User_11637 | Oct 01, 2017, 19:03 PM
  • i'm looking at the pro formal excel sheet right now. that's the one i'm confuse
    User_11637 | Oct 01, 2017, 19:04 PM
  • Year 1 2 3 4 5 6 Operating Cash Flows PGI 1,416,447.00 1,474,414.28 1,320,925.17 1,390,309.54 1,360,524.21 1,383,237.88 V&C - - 22,211.44 - 57,348.87 58,803.37 EGI 1,416,447.00 1,474,414.28 1,298,713.73 1,390,309.54 1,303,175.34 1,324,434.51 OE 513,315.00 513,315.00 513,315.00 513,315.00 513,315.00 513,315.00 NOI 903,132.00 961,099.28 785,398.73 876,994.54 789,860.34 811,119.51
    User_11637 | Oct 01, 2017, 19:05 PM
  • If you can explain how you get all those numbers, I will be able to submitted. The file 3, PGI, V&C, OE, NOI, DS, BTCF... Tax Liability, Equity reversion. Once you explain why those numbers, I will be able to pay you $200 total.
    User_11637 | Oct 01, 2017, 19:08 PM
  • how did you even find the sale price? Sales price 9,542,582.44
    User_11637 | Oct 01, 2017, 19:09 PM
  • I am sorry but please understand my point of view especially I don't even know how to do this. Obviously you are the smart one here. Thanks for your help.
    User_11637 | Oct 01, 2017, 19:10 PM
  • oh so many messages lol sorry I had stepped out a few minutes
    TheBest | Oct 01, 2017, 19:13 PM
  • wait, I know how you got the EGI OE NOI DS BTCF Tax ATCF
    User_11637 | Oct 01, 2017, 19:13 PM
  • I just need to know these numbers. how you got them. PGI V&C
    User_11637 | Oct 01, 2017, 19:13 PM
  • okay allow me some few minutes
    TheBest | Oct 01, 2017, 19:15 PM
  • and thanks for the bonus
    TheBest | Oct 01, 2017, 19:16 PM
  • Thank you very much.
    User_11637 | Oct 01, 2017, 19:17 PM
  • see uploaded file
    TheBest | Oct 01, 2017, 20:10 PM
  • This is perfect! so that's how you got those numbers I see!!! I just need year 4, 5 and 6 and I am good!!!
    User_11637 | Oct 01, 2017, 20:19 PM
  • check I already uploaded for for year 4-6 just refresh and you'll see the files
    TheBest | Oct 01, 2017, 20:21 PM
  • all good?
    TheBest | Oct 01, 2017, 20:33 PM
  • yes. Very good! thank you.
    User_11637 | Oct 01, 2017, 20:38 PM
  • You're most welcome hope you will give me 10/10 rating as well as consider me for your future assignments
    TheBest | Oct 01, 2017, 20:41 PM
  • you get 11/10 rating. I will give you a great rating and for sure using you for my future assignments. I had a guy did the work for me, and I got 0% because I wasn't able to explained to my professor how i got those info. Long story short, I never use him again.
    User_11637 | Oct 01, 2017, 20:52 PM
  • Awe! You're a great client. You can trust me with any assignment be it research papers/online classes etc anything even if it is not finance lol. Hey and sorry for the past experience with the said writer
    TheBest | Oct 01, 2017, 20:57 PM
  • Hello, So i have an assignment coming up in couple days. It's a business law ethic essay. I have 45 mins to completed. I won't know the topic until I open the window, once I open the window, I will have 45 mins to complete. I can provide you some guidelines and rubrics before we get started. R u up for this assignment?
    User_11637 | Oct 02, 2017, 20:30 PM
  • Great! yeah sure I can help..you can send the guideline/rubric or a practice essay (if already provided)
    TheBest | Oct 02, 2017, 20:32 PM
  • should I just post a new work for the essay? it's due on Saturday. once I open the assignment, I must finish it within 45 mins. I won't know the topic until I open it, so by the time I open it, send it to you... you will have 40 mins to complete it. I will upload the rubics here?
    User_11637 | Oct 03, 2017, 19:15 PM
  • yes kindly upload it as a new task..maybe with the title...For TheBest
    TheBest | Oct 03, 2017, 19:17 PM
  • so i uploaded the new task with the title THE BEST. So what time will you be able to have 30-40 mins available to do this on saturday morning?
    User_11637 | Oct 06, 2017, 00:53 AM
  • Hi sorry I was sleeping...just placed my bid. What's your current time? I need to know so that we agree on what time I should do it
    TheBest | Oct 06, 2017, 05:46 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
smartestwriter 9 years ago
Rated 9.54 earned 25983.04 around 898 assignments.
I believe I am the right fit for this job. I am diligent, hardworking and self-driven. I am interested in this project because I love writing, I have been doing it for over five years and it is my passion. I always keep my deadlines and you will not be disappointed by the quality of my work. I hope you choose me to work on this project.
$150.00
  • All my prices are negotiable if you are willing to establish an academic long-term relationship.
    smartestwriter | Sep 20, 2017, 18:02 PM
  • I complete all my assignments before deadline usually and hour or two before so you can have ample time to review the job and request of corrections if any.
    smartestwriter | Sep 20, 2017, 18:02 PM
  • I have done a similar job to this one last month and I am pretty confident I can do it as easily and fast as possible.
    smartestwriter | Sep 20, 2017, 18:03 PM
  • Do you know how to calculate Real Estates business finance? And must show how and why for the numbers
    User_11637 | Sep 20, 2017, 18:05 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
1stclasshonour 9 years ago
Rated 9.22 earned 30856.96 around 773 assignments.
helllo my friend
$150.00
  • Do you know how to calculate Real Estates business finance? And must show how and why for the numbers
    User_11637 | Sep 20, 2017, 18:05 PM
  • yes i know
    User_10376 | Sep 20, 2017, 18:10 PM
  • have done similar assignment , kindly assign me so that i can start working on it
    User_10376 | Sep 20, 2017, 18:11 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
expert4u 9 years ago
Rated 9.0 earned 77109.21 around 2331 assignments.
Trust my services and rest assured that you will get quality, plagiarism free and timely delivered work. Please consider my bid. Thank you
$150.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
Javawriter 9 years ago
Rated 8.81 earned 69150.66 around 2092 assignments.
HI,Concerning the homework that you want done for you, am the right person to do it. I am an American native and I have a PHD in sociology also PHD in business administration.I assure you a content homework and nothing less than an A. I have written various articles and be rest assured i will deliver a timely,quality,substantial and PLAGIARISM free work. Thanks in advance
$150.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}