In Excel,

2.2 and 2.3 please

NCF for 2.0 is $45,711,048.

Now that we've found the value of a stabilized 100 key hotel in Seattle, Let's try to work backwards to find how much to pay for land. It will take 12 months to build the hotel after land acquisition. Carrv over vour value using NCF from Question 1.3 Grade: Now we find out if we make any money developing the property. Each room averages 305sf in size, and the average hotel is 80% efficient in total buildable area. Soft costs are $82 psf and hard costs are $410 psf. Minimal site improvements needed, but city wants to upgrade sewage to site for $5 million. Site is asking for $12 million. Grade: 18 Now let's look at our construction loan. Land acquisition is made with all equity, the rest of the costs are made with even construction draws in Month 0 1 2 3 5 6 7 Equity (Acquisition) Construction Loan Draws Calculate the Construction balloon (Principal and interest) due in Month 12 based on a 7% interest rate. hint use FV formula on each cash flow and add them all at month 12 Grade: 15 Balloon Due Total Interest Calculate the developer's profit or loss (value - cost), rememeber to add interest to your costs. Now that we've found the value of a stabilized 100 key hotel in Seattle, Let's try to work backwards to find how much to pay for land. It will take 12 months to build the hotel after land acquisition. Carrv over vour value using NCF from Question 1.3 Grade: Now we find out if we make any money developing the property. Each room averages 305sf in size, and the average hotel is 80% efficient in total buildable area. Soft costs are $82 psf and hard costs are $410 psf. Minimal site improvements needed, but city wants to upgrade sewage to site for $5 million. Site is asking for $12 million. Grade: 18 Now let's look at our construction loan. Land acquisition is made with all equity, the rest of the costs are made with even construction draws in Month 0 1 2 3 5 6 7 Equity (Acquisition) Construction Loan Draws Calculate the Construction balloon (Principal and interest) due in Month 12 based on a 7% interest rate. hint use FV formula on each cash flow and add them all at month 12 Grade: 15 Balloon Due Total Interest Calculate the developer's profit or loss (value - cost), rememeber to add interest to your costs