Financial real esatte question. i just need required a2, b1, and b2!

Req A1

Estimate the construction draw schedule, interest carry, and total loan amount for improvements. (Enter your answers in dollars, not in million: Round your final answers to the nearest whole amount.)

Req A2

Req B1

Req B2

This is all of the info I am given :)

As a financial advisor for the Spain Development Company, you have been given the construction and marketing studies for the proposed Timbercreek office project. Several potential sites have been selected, but a final decision has not been made. Your. manager needs to know how much she can afford to pay for the land and still manage to return 16 percent on the entire project over its lifetime. The strategic plan calls for a construction phase of one year and an operation phase of five years, after which time the property will be sold. The marketing staff says that a 1.3-acre site will be adequate because the initial studies indicate that this site will support an office building with a gross leasable area (GLA) of 26,520 square feet. The gross bullding area (GBA) will be 31,200 square feet, giving a leasable ratio of 85 percent. The marketing staff further assures you that the space can be rented for $20.0 per square foot. The head of the construction division maintains that all direct costs (excluding interest carry and all loan fees) will be $3.5 million. The First Street Bank will provide the construction loan for the project. The bank will finance all of the construction costs, site improvements, and interest carry at an annual rate of 6 percent plus a loan origination fee of 15 points. The construction division estimates that the direct cost draws will be taken down in six equal amounts commencing with the first month after close. The permanent financing for the project will come at the end of the first year from the Rellable Company at an interest rate of 5 percent With a 4 percent prepaid loan fee. The loan has an eight-year term and is to be paid back monthly over a 25 -year amortization schedule. No financing fees will be included in elther loan amount. Spain will fund acquisition of the land with its own equity. Spain expects tenant reimbursements for the project to be $3.75 per square foot and the office building to be 75 percent leased during the first year of operation. After that, vacancies should average about 5 percent of GPI per year Rents, tenant reimbursement, and operating expenses are expected to increase by 3 percent per year during the lease period. The operating expenses are expected to be $10.00 per square foot. The final sales price is based on the NO/ in the sixth year of the project (the fitt year of operation) capitalized at 9.5 percent. The project will incur sales expenses of 4 percent. Spain is concerned that it may not be able to afford to pay for the land and still earn 16 percent (before taxes) on its equity (remember that the land acquisition cost must be paid from Spain's equity). To consider project feasibility. Required: a1. Estimate the construction draw schedule, interest carry, and total loan amount for improvements. a2. Determine total project cost (including fees) less financing and the equity needed to fund improvements. b1. Estimate cash flows from operations. b2. Estimate cash flow from eventual sale, c. After discounting equity cash inflows andfoutllows, is the NPV positive or negative? d. If the asking price of the land were $345.000, would this project be feasible? Determine total project cost (including fees) less financing and the equity needed to fund improvements. (Enter your answers n dollars, not in millions. Do not round intermediate calculations. Round your final answer to the nearest whole dollar.) Estimate cash flows from operations. (Enter your answers in dollars, not in millions. Do not round intermediate calculations. Round your final answer to the nearest whole dollar. Negative amounts should be indicated by a minus sign.) stimate cash flow from eventual sale. (Enter your answers in dollars, not in millions. Do not round intermediate calculations. tound your final answer to the nearest whole dollar) As a financial advisor for the Spain Development Company, you have been given the construction and marketing studies for the proposed Timbercreek office project. Several potential sites have been selected, but a final decision has not been made. Your manager needs to know how much she can afford to pay for the land and still manage to return 16 percent on the entire project over its lifetime. The strategic plan calls for a construction phase of one year and an operation phase of five years, after which time the property will be sold. The marketing staff says that a 1,3-acre site will be adequate because the initial studies indicate that this site will support an office building with a gross leasable area (GLA) of 26,520 square feet. The gross building area (GBA) will be 31,200 square feet, giving a leasable ratio of 85 percent. The marketing staff further assures you that the space can be rented for $20.0 per square foot. The head of the construction division maintains that all direct costs (excluding interest catry and all loan fees) will be $3.5 million. The First Street Bank will provide the construction loan for the project. The bank will finance all of the construction costs, site improvements, and interest carry at an annual rate of 6 percent plus a loan origination fee of 1.5 points. The construction division estimates that the direct cost draws will be taken down in six equal amounts commencing with the first month after close. The permanent financing for the project will come at the end of the first year from the Reliable Company at an interest rate of 5 percent With a 4 percent prepaid loan fee. The loan has an elght-year term and is to be paid back monthly over a 25 -year amortization schedule. No financing fees will be included in either loan amount. Spain will fund acquisition of the land with its own equity. Spain expects tenant reimbursements for the project to be $3.75 per square foot and the office building to be 75 percent leased during the first year of operation. After that, vacancies should average about 5 percent of GPI per year. Rents, tenant reimbursement, and operating expenses are expected to increase by 3 percent per year during the lease period. The operating expenses are expected to be $10.00 per square foot. The final sales price is based on the NOl in the sixth year of the project (the fifth year of operation) capitalized at 9.5 percent. The project will incur sales expenses of 4 percent. Spain is concerned that it may not be able to afford to pay for the land and still earn 16 percent (before taxes) on its equity (remember that the land acquisition cost must be paid from Spain's equity). To consider project feasibility. Determine total project cost (including fees) less financing and the equity needed to fund improvements. (Enter your answers in dollars, not in millions. Do not round intermediate calculations. Round your final answer to the nearest whole dollar.) Estimate cash flows from operations. (Enter your answers in dollars, not in millions. Do not round intermediate calculations. Round your final answer to the nearest whole dollar. Negative amounts should be indicated by a minus sign.) stimate cash flow from eventual sale. (Enter your answers in dollars, not in millions. Do not round intermediate calculations Lound your final answer to the nearest whole dollar.) As a financial advisor for the Spain Development Company, you have been given the construction and marketing studies for the proposed Timbercreek office project. Several potential sites have been selected, but a final decision has not been made. Your. manager needs to know how much she can afford to pay for the land and still manage to return 16 percent on the entire project over its lifetime. The strategic plan calls for a construction phase of one year and an operation phase of five years, after which time the property will be sold. The marketing staff says that a 1.3-acre site will be adequate because the initial studies indicate that this site will support an office building with a gross leasable area (GLA) of 26,520 square feet. The gross bullding area (GBA) will be 31,200 square feet, giving a leasable ratio of 85 percent. The marketing staff further assures you that the space can be rented for $20.0 per square foot. The head of the construction division maintains that all direct costs (excluding interest carry and all loan fees) will be $3.5 million. The First Street Bank will provide the construction loan for the project. The bank will finance all of the construction costs, site improvements, and interest carry at an annual rate of 6 percent plus a loan origination fee of 15 points. The construction division estimates that the direct cost draws will be taken down in six equal amounts commencing with the first month after close. The permanent financing for the project will come at the end of the first year from the Rellable Company at an interest rate of 5 percent With a 4 percent prepaid loan fee. The loan has an eight-year term and is to be paid back monthly over a 25 -year amortization schedule. No financing fees will be included in elther loan amount. Spain will fund acquisition of the land with its own equity. Spain expects tenant reimbursements for the project to be $3.75 per square foot and the office building to be 75 percent leased during the first year of operation. After that, vacancies should average about 5 percent of GPI per year Rents, tenant reimbursement, and operating expenses are expected to increase by 3 percent per year during the lease period. The operating expenses are expected to be $10.00 per square foot. The final sales price is based on the NO/ in the sixth year of the project (the fitt year of operation) capitalized at 9.5 percent. The project will incur sales expenses of 4 percent. Spain is concerned that it may not be able to afford to pay for the land and still earn 16 percent (before taxes) on its equity (remember that the land acquisition cost must be paid from Spain's equity). To consider project feasibility. Required: a1. Estimate the construction draw schedule, interest carry, and total loan amount for improvements. a2. Determine total project cost (including fees) less financing and the equity needed to fund improvements. b1. Estimate cash flows from operations. b2. Estimate cash flow from eventual sale, c. After discounting equity cash inflows andfoutllows, is the NPV positive or negative? d. If the asking price of the land were $345.000, would this project be feasible? Determine total project cost (including fees) less financing and the equity needed to fund improvements. (Enter your answers n dollars, not in millions. Do not round intermediate calculations. Round your final answer to the nearest whole dollar.) Estimate cash flows from operations. (Enter your answers in dollars, not in millions. Do not round intermediate calculations. Round your final answer to the nearest whole dollar. Negative amounts should be indicated by a minus sign.) stimate cash flow from eventual sale. (Enter your answers in dollars, not in millions. Do not round intermediate calculations. tound your final answer to the nearest whole dollar) As a financial advisor for the Spain Development Company, you have been given the construction and marketing studies for the proposed Timbercreek office project. Several potential sites have been selected, but a final decision has not been made. Your manager needs to know how much she can afford to pay for the land and still manage to return 16 percent on the entire project over its lifetime. The strategic plan calls for a construction phase of one year and an operation phase of five years, after which time the property will be sold. The marketing staff says that a 1,3-acre site will be adequate because the initial studies indicate that this site will support an office building with a gross leasable area (GLA) of 26,520 square feet. The gross building area (GBA) will be 31,200 square feet, giving a leasable ratio of 85 percent. The marketing staff further assures you that the space can be rented for $20.0 per square foot. The head of the construction division maintains that all direct costs (excluding interest catry and all loan fees) will be $3.5 million. The First Street Bank will provide the construction loan for the project. The bank will finance all of the construction costs, site improvements, and interest carry at an annual rate of 6 percent plus a loan origination fee of 1.5 points. The construction division estimates that the direct cost draws will be taken down in six equal amounts commencing with the first month after close. The permanent financing for the project will come at the end of the first year from the Reliable Company at an interest rate of 5 percent With a 4 percent prepaid loan fee. The loan has an elght-year term and is to be paid back monthly over a 25 -year amortization schedule. No financing fees will be included in either loan amount. Spain will fund acquisition of the land with its own equity. Spain expects tenant reimbursements for the project to be $3.75 per square foot and the office building to be 75 percent leased during the first year of operation. After that, vacancies should average about 5 percent of GPI per year. Rents, tenant reimbursement, and operating expenses are expected to increase by 3 percent per year during the lease period. The operating expenses are expected to be $10.00 per square foot. The final sales price is based on the NOl in the sixth year of the project (the fifth year of operation) capitalized at 9.5 percent. The project will incur sales expenses of 4 percent. Spain is concerned that it may not be able to afford to pay for the land and still earn 16 percent (before taxes) on its equity (remember that the land acquisition cost must be paid from Spain's equity). To consider project feasibility. Determine total project cost (including fees) less financing and the equity needed to fund improvements. (Enter your answers in dollars, not in millions. Do not round intermediate calculations. Round your final answer to the nearest whole dollar.) Estimate cash flows from operations. (Enter your answers in dollars, not in millions. Do not round intermediate calculations. Round your final answer to the nearest whole dollar. Negative amounts should be indicated by a minus sign.) stimate cash flow from eventual sale. (Enter your answers in dollars, not in millions. Do not round intermediate calculations Lound your final answer to the nearest whole dollar.)