Bohan, A Course Project
.pdf
keyboard_arrow_up
School
Cornell University *
*We aren’t endorsed by this school
Course
6628
Subject
Finance
Date
Apr 3, 2024
Type
Pages
11
Uploaded by UltraRiver13685 on coursehero.com
COURSE PROJECT Feasibility and Market Analysis Instruction
s
In this course project, you will explore how cash flow forecasting is based on a series of assumptions that can and should change with more information
. Except as indicated, use this document to record all your project work and responses to any questions. At a minimum, you will need to turn in a digital copy of this document to your facilitator as part of your project completion. You may also have additional supporting documents that you will need to submit. Note: Though your work will only be seen by those grading the course and will not be used or shared outside the course, you should take care to obscure any information you feel might be of a sensitive or confidential nature. Complete each project part as you progress through the course. Wait to submit the project until all parts are complete. Begin your course project by completing Part One below. Submit your completed project on the final project assignment page online. Information about the grading rubric is available on any of the course project assignment pages online. Do not hesitate to contact your facilitator if you have any questions about the project. 1
Feasibility and Market Analysis Nolan School of Hotel Administration © 2023 Cornell University
Part One Forecasting Rents and Occupancy Rates In this part of the course project, you will provide your estimate of the stabilized occupancy for the various components of Cayustoga Center as summarized in the provided rent roll spreadsheet. To complete this part of the course project, you will review the Cayustoga Center rent roll spreadsheet and summarized information below from the supply and demand analysis performed in this module. Using your estimates of the capture rates for each of the components, you will complete the occupancy forecast. The supply and demand analysis in this module revealed the following: ●
The multi-family units are approximately 8.4% of the existing supply of four- and five-
star apartment units in the Lancaster metro area. ●
The multi-family units will take two years to stabilize. o
Year 1 vacancy is expected to be 15%. o
Year 2 vacancy is expected to be better than the market; the project will capture more than its fair share of demand. In addition, the opening of the project is expected to serve the significant unaccommodated demand in the market. ▪
The expected market vacancy for four- to five-star multi-family units is expected to be 1.7% in Year 2. ●
The retail is approximately 2.7% of the existing supply of neighborhood retail in the Lancaster metro area. o
The Upscale Grocery Anchor site will be fully occupied from the start of the project under a 30-year ground lease. o
The Main Street Retail space will take three years to stabilize. ▪
Year 1 vacancy is expected to be 30%. ▪
Year 2 vacancy is expected to be 15%. ▪
Year 3 vacancy is expected to be better than the market because the Main Street portion of the project will capture more than its fair share of demand. In addition, the grocery-anchored portion of the retail project will be fully occupied on a ground lease from Day 1. ●
The expected market vacancy for Neighborhood Retail is expected to be 7.0% in Year 3. 2
Feasibility and Market Analysis Nolan School of Hotel Administration © 2023 Cornell University
Instructions: 1.
Complete the Cayustoga rent roll spreadsheet using your estimates of the capture rate. The spreadsheet mirrors the information above with one exception: The capture rate is specified at 100% as shown in the blue cells.
2.
Provide a summary projection of the stabilized occupancy. You can find this information in the spreadsheet calculated in the Occupancy tab, Column K, Rows 6, 7, and 8.
Enter response: The Main Street would have a 93% occupancy and the Apartments would have an 98.3% occupancy. 3.
Provide a justification for each capture rate estimate. Offer a short narrative detailing why you feel the capture rate is correct.
Note
: Your capture rate estimate cannot result in a project occupancy of more than 100%.
Enter response: The Main Street would have a 93% occupancy and the Apartments would have an 98.3% occupancy. Both of these are solid estimates. Since the multi-
family units make up 8.4% of the apartments in the Lancaster area, there are many attractive amenities, great location, and they are new I believe this number would be fairly accurate. In regards to the retail component, I think with the fact that they offer a range of retail including both national and local, and they plan to be around 93% occupancy by the 3rd year this is also an accurate description. 3
Feasibility and Market Analysis Nolan School of Hotel Administration © 2023 Cornell University
Part Two Forecasting Revenues, Expenses, and Cash Flows In this part of the course project, you will use the Cash Flow Estimates Template spreadsheet for the Cayustoga Center to focus on benchmarking and a “what if” analysis. To complete this part of the course project, you will benchmark expenses for a provided scenario using both external sources and best practices provided in this module. You will then perform a “what if” analysis to explore cash flows when certain parameters are changed. You may refer back to the Cash Flow Estimates Template Instructions to assist you. Part A — Benchmarking Instructions: Review the following scenario and update the “Cash Flow Estimates” spreadsheet based on the provided information. Scenario: Imagine you work for RealCo, the developer of the proposed Cayustoga Center project. You are responsible for helping to finalize the forecast of revenues and expenses for the project. The project was put on hold for various reasons, and you were provided with the projected performance when the project was shelved. The occupancy forecast has both the updated market occupancy and capture rates for the various spaces. The market occupancy forecast has been updated using external sources and the capture rate is determined by your evaluation of the project’s relative positioning within the market. To complete the forecast of revenues, your RealCo team has updated the inputs as follows: ●
Miscellaneous retail revenues will start at $0.21 per square foot. ○
Inflation is expected to be 4% in Year 2, 3.5% in Year 3, and 3% in Years 4 and 5. ●
Miscellaneous multi-family revenues will start at $310 per unit. ○
Inflation is expected to be 4% in Year 2, 3.5% in Year 3, and 3% in Years 4 and 5. 4
Feasibility and Market Analysis Nolan School of Hotel Administration © 2023 Cornell University
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
For the portfolio project, you will select a topic of interest to you (please avoid controversial topics like diversity & inclusion, politics and religion). It should be a topic that you can develop a survey and obtain feedback to analyze and present results. You can choose quantitative, qualitative, or mixed method (if you want to practice both quantitative and qualitative analysis). Your portfolio project will have four deliverables; three milestones and a final submission.
Milestone #1 – Research Project Overview (Week Two)
Introduction: Provide a brief overview of the research project. Describe the topic you are focusing on and establish the rationale behind your choice. Use the model for introduction on page 111 in Creswell & Creswell.
Purpose: Describe the main topics that you will examine in the context of the survey. You do not need to discuss the specific survey questions here. Rather, focus on the broader topics and themes that you will address in the…
arrow_forward
Assess project risk in a financial analysis
discuss steps and explain importance. Will leave a thumbs up, thank you
arrow_forward
Prepare an information memorandum for the project to be presented to the potential financiers. Among others it should contain the following:
1. The full business description of the project
2. An analysis of the key risks facing the project and the ways of mitigating the risk.
3. The proposed financing structure and justification for using that particular structure.
arrow_forward
In a single sentence, explain how you can determine which cash flows should be included in the analysis of a project.
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
arrow_forward
You can come across different situations in your life where the concepts from capital budgeting will help you in evaluating the situation and making calculated decisions. Consider the following situation:
The following table contains five definitions or concepts. Identify the term that best corresponds to the concept or definition given.
Concept or Definition
Term
A computer-generated probability simulation of the most likely outcome, given a set of probable future events
The most likely scenario in a capital budgeting analysis
A measure of the project’s effect on the firm’s earnings variability
The risk that is measured by the project’s beta coefficient
A successful sushi chain in Hong Kong spent $500,000 to conduct a study on whether to open a location in the United States. The study showed that the best place for the company to open its first location would be in Chicago. When conducting its capital budgeting analysis, how should…
arrow_forward
All parts are under one questions and per your policy therefore all parts can be answered.
1. Concepts used in cash flow estimation and risk analysis
You can come across different situations in your life where the concepts from capital budgeting will help you in evaluating the situation and making calculated decisions. Consider the following situation:
The following table contains five definitions or concepts. Identify the term that best corresponds to the concept or definition given.
A.
Concept or Definition
Term
A computer-generated probability simulation of the most likely outcome, given a set of probable future events
The most likely scenario in a capital budgeting analysis
A measure of the project’s effect on the firm’s earnings variability
A method to determine market risk by using the betas of single-product companies in a given industry
The risk that is measured by the project’s beta coefficient
B. Marston…
arrow_forward
Describe one of the many financial applications of the time value of money e.g. capital project evaluation, annuity, regular payment for amortization of a loan, etc. Provide an example situation with dollar figures and utilizing the correct present value or future value formula for your chosen example to illustrate the time value of money concept and show your keystrokes on your financial calculator.
arrow_forward
Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…
arrow_forward
Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…
arrow_forward
Instructions:
Imagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area.
Project 1
Callaloo Collaborators, Inc. has been considering several capital investment proposals for the year beginning in 2019. For each investment proposal, the relevant cash flows and other relevant financial data are summarized in the table below. New assets will be depreciated under the MACRS system rather than being fully expensed right away. In the case of a replacement decision, the…
arrow_forward
Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…
arrow_forward
how to assess financial support project whether there is a need to conduct a financial analysis. What are the possible aspects you will consider in conducting a financial analysis of that project?
arrow_forward
Use the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the present value tables provided in APPENDICES1. Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand).Use your answers to recommend the project that should be chosen. Motivateyour choice.
arrow_forward
Build an Excel Model to compute the NPV of investment project I or II and make sure that the model works
arrow_forward
Outlining the capital budgeting process
Review the following activities of the capital budgeting process:
Budget capital investments.
Project investments’ cash flows.
Perform post-audits.
Make investments.
Use feedback to reassess investments already made.
Identify potential capital investments.
Screen/analyze investments using one or more of the methods discussed.
Place the activities in sequential order as they occur in the capital budgeting process.
arrow_forward
Outlining the capital budgeting process
Review the following activities of the capital budgeting process:
a. Budget capital investments.
b. Project investments’ cash flows.
c. Perform post-audits.
d. Make investments.
e. Use feedback to reassess investments already made.
f. Identify potential capital investments.
g. Screen/analyze investments using one or more of the methods discussed.
Place the activities in sequential order as they occur in the capital budgeting process.
arrow_forward
The last step in the financial planning process is to
Group of answer choices
use financial statements to evaluate results of plans and budgets, taking corrective action as required
implement financial plans and strategies.
periodically develop and implement budgets to monitor and control progress toward goals
redefine goals and revise plans and strategies as personal circumstances change
develop financial plans and strategies to achieve goals
arrow_forward
Imagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area.
Harris Dance Company, Inc., a manufacturer of dance and exercise apparel, is considering replacing an existing piece of equipment with a more sophisticated machine. The following information is given.
The firm pays 40 percent taxes on ordinary income and capital gains.
Project 2 Questions:
1) Calculate the book value of the existing asset being replaced.
2) Calculate the tax effect from the sale…
arrow_forward
Imagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area.
Carolina Company, Inc. is considering purchasing a new gluing machine. The gluing machine costs $50,000 and requires installation costs of $2,500. The sale of an existing gluer would partially offset this outlay. The existing gluer originally cost $10,000 and is four years old. It is being depreciated under MACRS using a five-year recovery schedule and can currently be sold for $15,000. The existing gluer…
arrow_forward
according to the conditions of the question (show in below pic.)
What further information might you consider or need before making a final investment decision?
arrow_forward
QUESTION 1
The accounts manager of VM Gym & Sports has been asked to evaluate a potential capital
investment of a set of rowing machines. The following data is available for cach project:
Machine 1
Machine 2
RM
RM
Cost (immediate outlay)
500,000
245,000
Expected annual profits (losses)
Year 1
I.
80,000
84,000
Year 2
90,000
136,000
Year 3
116,000
126,000
Year 4
146,000
150,000
Annual running costs
30,000
24,000
Annual service costs
36,000
20,000
Estimated residual value equipment
40,000
30,000
*The total annial running and service costs for Machine 2 in the first year is RM 36,000
The committee has estimated a cost of capital of 30% and employs the straight-line method
of depreciation for all fixed assets when calculating net profit. The following discount factors
are given:
Year
Cost of capital
10%
50%
0.909
0.667
2.
0.826
0.444
3.
0.751
0.296
4.
0.683
0.198
arrow_forward
Can you use the images attached to calculate the initial cash flow of the project. PLease explain how it is calculated as well.
arrow_forward
Define “the stand-alone principle” applying in evaluating projects and discuss the types of cashflows in project evolution.
arrow_forward
How to improve the likelihood of successful adoption of a new information systems that members of the finance department will use
arrow_forward
Can someone help me figure out this problem?
Complete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your…
arrow_forward
discusses the acronym TELOS which provides guidance for accessing project feasibility. The term stands for technical, economic, legal, operational and schedules feasibility. Discuss these feasibilities briefly. And elaborate cost-benefit analysis under economic feasibility.
b) Accountants should be involved in the detailed design and implementation of the system development life cycle. Comment on the statement.
arrow_forward
As project manager, give your opinion regarding decision of projects using NPV, PI, IRR and payback period.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Related Questions
- For the portfolio project, you will select a topic of interest to you (please avoid controversial topics like diversity & inclusion, politics and religion). It should be a topic that you can develop a survey and obtain feedback to analyze and present results. You can choose quantitative, qualitative, or mixed method (if you want to practice both quantitative and qualitative analysis). Your portfolio project will have four deliverables; three milestones and a final submission. Milestone #1 – Research Project Overview (Week Two) Introduction: Provide a brief overview of the research project. Describe the topic you are focusing on and establish the rationale behind your choice. Use the model for introduction on page 111 in Creswell & Creswell. Purpose: Describe the main topics that you will examine in the context of the survey. You do not need to discuss the specific survey questions here. Rather, focus on the broader topics and themes that you will address in the…arrow_forwardAssess project risk in a financial analysis discuss steps and explain importance. Will leave a thumbs up, thank youarrow_forwardPrepare an information memorandum for the project to be presented to the potential financiers. Among others it should contain the following: 1. The full business description of the project 2. An analysis of the key risks facing the project and the ways of mitigating the risk. 3. The proposed financing structure and justification for using that particular structure.arrow_forward
- In a single sentence, explain how you can determine which cash flows should be included in the analysis of a project. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).arrow_forwardYou can come across different situations in your life where the concepts from capital budgeting will help you in evaluating the situation and making calculated decisions. Consider the following situation: The following table contains five definitions or concepts. Identify the term that best corresponds to the concept or definition given. Concept or Definition Term A computer-generated probability simulation of the most likely outcome, given a set of probable future events The most likely scenario in a capital budgeting analysis A measure of the project’s effect on the firm’s earnings variability The risk that is measured by the project’s beta coefficient A successful sushi chain in Hong Kong spent $500,000 to conduct a study on whether to open a location in the United States. The study showed that the best place for the company to open its first location would be in Chicago. When conducting its capital budgeting analysis, how should…arrow_forwardAll parts are under one questions and per your policy therefore all parts can be answered. 1. Concepts used in cash flow estimation and risk analysis You can come across different situations in your life where the concepts from capital budgeting will help you in evaluating the situation and making calculated decisions. Consider the following situation: The following table contains five definitions or concepts. Identify the term that best corresponds to the concept or definition given. A. Concept or Definition Term A computer-generated probability simulation of the most likely outcome, given a set of probable future events The most likely scenario in a capital budgeting analysis A measure of the project’s effect on the firm’s earnings variability A method to determine market risk by using the betas of single-product companies in a given industry The risk that is measured by the project’s beta coefficient B. Marston…arrow_forward
- Describe one of the many financial applications of the time value of money e.g. capital project evaluation, annuity, regular payment for amortization of a loan, etc. Provide an example situation with dollar figures and utilizing the correct present value or future value formula for your chosen example to illustrate the time value of money concept and show your keystrokes on your financial calculator.arrow_forwardComplete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…arrow_forwardComplete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…arrow_forward
- Instructions: Imagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area. Project 1 Callaloo Collaborators, Inc. has been considering several capital investment proposals for the year beginning in 2019. For each investment proposal, the relevant cash flows and other relevant financial data are summarized in the table below. New assets will be depreciated under the MACRS system rather than being fully expensed right away. In the case of a replacement decision, the…arrow_forwardComplete the following homework scenario:Compare the results of the three methods by quality of information for decision making. Using what you have learned about the three methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three methods. Review the video titled "NPV, IRR, MIRR for Mac and PC Excel" (located at and previously listed in Week 4) to help you understand the foundational concepts:Scenario Information:Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision…arrow_forwardhow to assess financial support project whether there is a need to conduct a financial analysis. What are the possible aspects you will consider in conducting a financial analysis of that project?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,