Category: Finance

THE GUIDE IS IN THE PDF FILE OF THE EXACT INSTRUCTIONS, THIS IS JUST ALL EXTRA I

THE GUIDE IS IN THE PDF FILE OF THE EXACT INSTRUCTIONS, THIS IS JUST ALL EXTRA INFORMATION TO HELP GUIDE YOU WRITE THE PAPER. This is an exercise in risk analysis of a real world problem. He specifically said to use things we have learned in the class to make my case. Consider using repricing gap analysis, duration gap analysis and VAR to make your case. These topics are almost every topic we have learned in the class. I prefer the ones above to be used but if you need extra things, here are other topics we have learned that you can use if the ones stated above are not enough Computing Returns, Risk Measures, Histogram and Frequency Distribution, Monte Carlo Simulation, Univariate regression, Testing the CAPM, The size and value anomalies, The Fama-French model, Arbitrage pricing model, Interest rate risk faced by the FI, Term structure of interest rates, Repricing model, Maturity model (market value-based), Duration, Duration gap model, Economic interpretation of duration, Immunization using duration, Problems in applying duration. This bank is in trouble because of…. [list risk factors and their impact]. You should look at other banks with similar financials, as well, for comparison. The one page is the summary of the analysis. Supporting Excel or Word docs need to provide proof and details of the report. Yahoo Finance is a better place for balance sheet analysis instead of 10K filing. However, reading the Risk Factors of the 10K filing makes your work a bit easier as the company directly states what they are their risks, both quantitative and qualitative.

The person who’s going to work on this project must have knowledge in Finance an

The person who’s going to work on this project must have knowledge in Finance and Real Estate in order to do this. Please read carefully the instructions in the Word document. No need for charts, tables, presentation, etc. I just need what is said in the instructions on the Word document.

Requirement:
Write a memo of 1.5 pages following the instructions that will be p

Requirement:
Write a memo of 1.5 pages following the instructions that will be provided to you. You must follow the details of the requirements that will be provided to you.
Note: I will attach details of the requirements with instructions to follow. This memo requires a baseline budget in an Excel spreadsheet.

TEAM Plans
$499 per seat
● TEAM Plans are unique in that we bill by seat rather

TEAM Plans
$499 per seat
● TEAM Plans are unique in that we bill by seat rather than by employee. This works
similar to licenses in other SaaS companies where the seats are interchangeable.
● For example, if a company plans to hire and grow, and they would like to lock-in
the price of $499 per employee, they can pre-purchase 10 “seats” for 12 months
(total cost of $59,880) which is paid upfront.
● The other unique feature of a TEAM Plan is that a company utilizing a TEAM
Plan has twelve months to start utilizing their seats. E.g. if a TEAM Plan starts on
2022-01-01, an employee can onboard 2022-12-01 and utilize the services for
the following 12 months.
● If a company does not initiate their seat credits at the end of the 12-month period,
they do not receive a refund (i.e. credits expire).
As the Finance Analyst, you have been asked to come up with a methodology to
calculate ARR for the TEAM Plans. Attached you will find sample data for 5 TEAM Plans that
have been booked by Sales in 2022 and the employees who have onboarded for those
companies.
As part of this analysis, you should create a short presentation with: i) methodologies you
considered, ii) your recommended methodology, and iii) the output of the ARR calculation for
TEAM Plans (you can assume the beginning ARR is zero) to present to the CFO

Dear Students,
Day’s Greetings.
I hope you are fine and in good health.
Assignme

Dear Students,
Day’s Greetings.
I hope you are fine and in good health.
Assignment No. 1 has been uploaded on your Blackboard. The due date for submitting the assignment is March 2nd, 2024. You are required to complete the assignment and submit it on or before the due date. Read all the instructions related to submitting the assignment and follow them carefully. Kindly fill in all the necessary information before submitting the assignment. Submit the assignment in MSWORD format. Be careful about plagiarism. Wish you all the best.
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder.
Assignments submitted through email will not be accepted.
Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page.
Students must mention question number clearly in their answer.
Late submission will NOT be accepted.
Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
All answers must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism.
Submissions without this cover page will NOT be accepted.

use excel document provided, how to arrive at cash flow, set up basic income sta

use excel document provided, how to arrive at cash flow, set up basic income statement in orderShow how arrived at cash flow
Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to reinforce your ideas.
Over lunch, you and Mary meet to discuss next steps with the expansion project.
“Do we have everything we need on sales and costs?” you ask. ”It must be time to compute the net present value (NPV) and internal rate of return (IRR) of the Apix expansion project.”
“We have the data from James and Luke regarding projected sales and costs, respectively, for the food packaging project,” says Mary. “It is feasible to project that we will receive a tax break from this implementation. I have information from our audit firm that indicates that future depreciation methods for taxes will be straight-line; however, the corporate rates will be reduced to 35% as we assumed in our weighted average cost of capital (WACC) calculation.”
“That sounds good,” you say.
“Right,” says Mary. “You can use a WACC of 10% for the computation of the NPV and comparison for IRR.”
“I’ve got the information I need from Luke and James,” you say. “Does this look right to you? Here’s what they gave me,” you say, as you hand a sheet of paper to Mary. “Let’s look at this now while we’re together,” she says.The information you hand to Mary shows the following:
Initial investment outlay of $30 million, consisting of $25 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal year
Project and equipment life: 5 years
Sales: $25 million per year for five years
Assume gross margin of 60% (exclusive of depreciation)
Depreciation: Straight-line for tax purposes
Selling, general, and administrative expenses: 10% of sales
Tax rate: 35%
You continue your conversation.
“It looks good,” says Mary. “Use this information from Luke and James to compute the cash flows for the project.”
“No problem,” you say.
“Then, compute NPV and IRR of the project using the Excel spreadsheet I sent earlier today,” says Mary. “Use the IRR financial function for the computation of IRR.”
“Okay,” you say. “I’ll submit my Excel file showing the computation of cash flows, NPV, and IRR by the end of week so you can look at it over the weekend.”
“Thanks,” says Mary.

Respond to the following in a minimum of 175 words:
Visit Yahoo Finance. Select

Respond to the following in a minimum of 175 words:
Visit Yahoo Finance. Select a public company that has not been selected by another student in the discussion and look up the company’s stock’s performance over the last year. Discuss which company you selected and its performance.
What do you think are the market forces that might have influenced the value of the company’s stock at its peaks and valleys?
What do your findings indicate about your selected company’s financial health?
Please use Walmart for the company.

You can find this case study in your course pack, please complete the assignment

You can find this case study in your course pack, please complete the assignment below:
1. Assuming Tottenham Hotspurs continue in their current stadium following their current player strategy:
Perform a DCF analysis using the cash flow projections given in the case. Based on this DCF analysis, what is the value of the Hotspurs?
Perform a multiple analysis. Based on the multiples analysis, is the value of Tottenham any different?
At its current stock price of £13.80, is Tottenham fairly valued?
2. Using a DCF approach, evaluate each of the following decisions:
Build the new stadium
Sign a new striker
Build the new stadium and sign a new striker
3. Based on the results from 2, select a best choice and provide a logical argument to support it.
Hints:
There are multiple ways to find the answer; individual’s answers may vary. Be sure to provide a logical reasoning for your assumptions.
Exhibit 5 provides values for Discounted Cash Flows
DCF can be done a couple ways, based on EBITDA or calculating Free Cash Flows
If you use the Free Cash Flow Method, you will also need to include capital acquisitions by year and change the net working capital by year
Regardless of method, you need to determine a terminal value of the business (the present value of a perpetuity)
Use 10.25% as the discount rate
Remember to determine the value you will need to subtract the value for debt
For adding a new stadium and new striker, you need to adjust your original DCF model and find the new cash flows. Remember to adjust for related revenues and expenses and recalculate the value of the enterprise.
Assume the Weighted Average Cost of Capital (WACC) is 10.25%

use excel document provided, how to arrive at cash flow, set up basic income sta

use excel document provided, how to arrive at cash flow, set up basic income statement in orderShow how arrived at cash flow
Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to reinforce your ideas.
Over lunch, you and Mary meet to discuss next steps with the expansion project.
“Do we have everything we need on sales and costs?” you ask. ”It must be time to compute the net present value (NPV) and internal rate of return (IRR) of the Apix expansion project.”
“We have the data from James and Luke regarding projected sales and costs, respectively, for the food packaging project,” says Mary. “It is feasible to project that we will receive a tax break from this implementation. I have information from our audit firm that indicates that future depreciation methods for taxes will be straight-line; however, the corporate rates will be reduced to 35% as we assumed in our weighted average cost of capital (WACC) calculation.”
“That sounds good,” you say.
“Right,” says Mary. “You can use a WACC of 10% for the computation of the NPV and comparison for IRR.”
“I’ve got the information I need from Luke and James,” you say. “Does this look right to you? Here’s what they gave me,” you say, as you hand a sheet of paper to Mary. “Let’s look at this now while we’re together,” she says.The information you hand to Mary shows the following:
Initial investment outlay of $30 million, consisting of $25 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal year
Project and equipment life: 5 years
Sales: $25 million per year for five years
Assume gross margin of 60% (exclusive of depreciation)
Depreciation: Straight-line for tax purposes
Selling, general, and administrative expenses: 10% of sales
Tax rate: 35%
You continue your conversation.
“It looks good,” says Mary. “Use this information from Luke and James to compute the cash flows for the project.”
“No problem,” you say.
“Then, compute NPV and IRR of the project using the Excel spreadsheet I sent earlier today,” says Mary. “Use the IRR financial function for the computation of IRR.”
“Okay,” you say. “I’ll submit my Excel file showing the computation of cash flows, NPV, and IRR by the end of week so you can look at it over the weekend.”
“Thanks,” says Mary.

Respond to the following in a minimum of 175 words:
Visit Yahoo Finance. Select

Respond to the following in a minimum of 175 words:
Visit Yahoo Finance. Select a public company that has not been selected by another student in the discussion and look up the company’s stock’s performance over the last year. Discuss which company you selected and its performance.
What do you think are the market forces that might have influenced the value of the company’s stock at its peaks and valleys?
What do your findings indicate about your selected company’s financial health?
Please use Walmart for the company.