I want you to build me a excel model for real estate valuation: (please make the inputs dynamic – i.e. I can change the numbers)…

Inputs:

Land size 1000 SQM

Land price =

Land commission= 1% of total land value; this is an expense

Number of villas=2

Total build up area = 1000 SQM (500 per villa)

Construction cost: 3000 per SQM…. This is a typical cost, if you want to make high-end villas you will spend more , but off course you will have ask for higher rent

Construction period = 2 years

Construction spent = 50% each year

Engineering cost = 2.5% of total construction cost

Rent per villa per month = 18,000 (rent increases by 5% every 3 years),,,usually you will get this from market study, just like an oil forecast, but assume this for now

Rent commission = 2 weeks rent per villa every 2 years (this is an expense)

Maintenance cost = 2.5% of rent, this is an expense

Case 1 = total equity zero debt model

Case 2 = bank will offer 60% financing on construction cost at a cost of debt of 4% (build the model that I can change this) / repayment over 10 years (2 years grace period = meaning you start paying the bank when you rent = year 3)

Please Build me a 15 year (annual) model (do not go crazy on terminal value)

Output

NPV@10% (again make 10% flexible)

IRR

AVP

NOI (net operating income = revenue – expenses on annual basis)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I was listening an undisclosed vinyl record when I was inspired to write this question. I changed the record player’s speed (angular speed) setting from 45 rpm to 33.3 rpm. let us approximate the angular acceleration alpha as constant and 0.750 seconds in duration.

this vinyl tecord is 17 cm in diameter and rotates clockwise.

1. first consider the time interval when the record is speeding up i.e during alpha

a. calculate the angular acceleration alpha

b calculate the angular displacement delta theta for the entire 0.750 sec and how many full circles (rev) is this?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I was just wondering if these were good examples of free indirect discourse in Pride and Prejudice? 

   “How differently did everything now appear in which he was concerned! His attentions to Miss King were now the consequence of views solely and hatefully mercenary; and the mediocrity of her fortune proved no longer the moderation of his wishes, but his eagerness to grasp at anything. His behaviour to herself could now have had no tolerable motive; he had either been deceived with regard to her fortune, or had been gratifying his vanity by encouraging the preference which she believed she had most incautiously shewn. Every lingering struggle in his favour grew fainter and fainter; and in farther justification of Mr. Darcy, she could not but allow that Mr. Bingley, when questioned by Jane, had long ago asserted his blamelessness in the affair; that proud and repulsive as were his manners, she had never, in the whole course of their acquaintance — an acquaintance which had latterly brought them much together, and given her a sort of intimacy with his ways — seen anything that betrayed him to be unprincipled or unjust — anything that spoke him of irreligious or immoral habits: that among his own connexions he was esteemed and valued — that even Wickham had allowed him merit as a brother, and that she had often heard him speak so affectionately of his sister as to prove him capable of some amiable feeling; that had his actions been what Wickham represented them, so gross a violation of everything right could hardly have been concealed from the world; and that friendship between a person capable of it, and such an amiable man as Mr. Bingley, was incomprehensible.”

and

  “From herself to Jane — from Jane to Bingley, her thoughts were in a line which soon brought to her recollection that Mr. Darcy’s explanation there had appeared very insufficient, and she read it again. Widely different was the effect of a second perusal. How could she deny that credit to his assertions, in one instance, which she had been obliged to give in the other. He declared himself to have been totally unsuspicious of her sister’s attachment; and she could not help remembering what Charlotte’s opinion had always been. Neither could she deny the justice of his description of Jane. She felt that Jane’s feelings, though fervent, were little displayed, and that there was a constant complacency in her air and manner not often united with great sensibility.”

thank you! 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I was having trouble with this question: If the nominal GDP is $559 billion in the base year, and it rises to 577 in Year 1, and 605 in Year 2, what is the real GDP in each year, given that the price index has risen from 100 to 104.5 in the first year and up to 108.3 in the second year? If the price index 20 years before the base year was 41.2, and the nominal GDP for 20 years before the base year was 191.0, what was the real GDP for that year? Show your work in all cases.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"