Category: Finance

I need answers for these problems only in Excel. Please make sure that you show

I need answers for these problems only in Excel. Please make sure that you show how you get the answers in Excel. Also, each problem must have is on sheet in Excel.

Please asnwer the question about the future of global finance with the material

Please asnwer the question about the future of global finance with the material I provided
Make sure read and use all the material I provided for you to answer the questions.
Q:What technologies do you think will most fundamentally change the face of global finance in the next 5-10 years, how and why?
You should have your arguement first. Please use material as reference in your answer to prove your idea. Don’t use AI and any AI related technolog. Univeristy checks AI very strictly.
references and material need to read:
“What are reserve assets; can Bitcoin become
one?” CNBCTV18, https://www.cnbctv18.com/cryptocurrency/what-are-reserve-assets-can- bitcoin-become-one-12835062.htm.
“How Many Bitcoins Are There? How Much Supply Left to
Mine?” BuyBitcoinWorldwide, https://buybitcoinworldwide.com/how-many-bitcoins-are- there/.
“Financial Inclusion on the Rise, But Gaps Remain, Global Findex Database Shows.” World Bank, https://www.worldbank.org/en/news/press-release/2018/04/19/financial-inclusion-on- the-rise-but-gaps-remain-global-findex-database-shows.
“How Many Transactions Per Second Ethereum: What is the TPS forETH?” Bitkan, https://bitkan.com/learn/how-many-transactions-per-second-ethereum-what-is- the-tps-for-eth-2698.
“Transactions Per Second (TPS) Definition.” CoinMarketCap, https://coinmarketcap.com/academy/glossary/transactions-per- second.
“The Collapse of Lehman Brothers: A Case Study.” Investopedia, https://www.investopedia.com/articles/economics/09/lehman-brothers- collapse.asp.
Casey, Michael et al. The impact of blockchain technology on finance: A catalyst for change. VoxEU. 2018.
The Economist. “Special report: The data economy.” 22 February 2020.
Rajan, Raghuram G. and Project Syndicate. “Regulating the Crypto Wild West.” Project Syndicate, 22 April 2022.
Streitfeld, David. “Silicon Valley Confronts the Idea That the ‘Singularity’ Is Here.” New York Times, 11 June 2023.
McCloskey, Deirdre N. “‘Power and Progress’ Review.” Wall Street Journal, 16 June 2023.
Adrian, Tobias and Tommaso Mancini-Griffoli. “Technology Behind Crypto Can Also Improve Payments,Providing a Public Good.” IMF Blog, 23 February 2023.
The Economist. “Economist Briefing on AI.” 22 April 2023, pp. 65-70.
Wolf, Martin. “The threat and promise of artificial intelligence.” Financial Times, 9 May 2023.
Perhach, Paulette. “Would You Take Financial Advice From A.I.?” New York Times, 20 May 2023.
Schmidt, Blake and Amanda Albright. “AI Is Coming for Wealth Management. Here’s What That Means.” Bloomberg News, 21 April 2023.
Tett, Gillian. “The dangers of letting AI loose on finance.” Financial Times, 27 April 2023.
Berkeley and Berlin. “How AI could change computing, culture and the course of history.” The Economist,20 April 2023.
The Economist. “Big tech pushes further into finance.” 15 December 2022.
McGee, Patrick and Joshua Franklin. “Will Apple take a big bite out of the banks?” Financial Times, 21 April 2023.

I only need you to answer questions 2, 3, and 9. With question 9 being about 3 p

I only need you to answer questions 2, 3, and 9. With question 9 being about 3 pages. I will answer the rest of the questions on my own. Again,, Questions 2, 3, 9. I will provide you an example of what the report should look like. The Example report I link will show you what ratios you would need to find to answer question 9. You would have to do research on yahoo finance or other websites to figure out those ratios for intel and other competitors. The questions are on the Project sample I linked below, Only questions 2 , 3, and 9 need to be answered. I will do the rest. Thank you. Please let me know if you need anything.

Just need report. Excel part is already done. I will provide completed excel she

Just need report. Excel part is already done. I will provide completed excel sheet after selecting the tutor
Part A and B are completed. Just do part C
A) Compute the following for each project:
i. The change in Net Working Capital (ΔNWC).
ii. The Free Cash Flows (FCF).
iii. The Net Present Value (NPV) with and without the terminal value.
iv. The Internal Rate of Return (IRR).
The Payback Period (PP) and the Discounted Payback Period (DPP).
vi. The Profitability Index (PI).
B) Perform sensitivity analysis for each project to gain insights about the impact of using a different discount rate and a different terminal value growth rate on each project’s NPV. This should be based on the different values for these rates provided in the accompanying Excel.
C) Based on the investment analysis you
performed write a report with your advice to Emily Harris. To this end,
initially summarize the different results obtained, including those from the
sensitivity analysis, and discuss and justify your recommendation. Then,
highlight any issues with the analysis that she should be aware of; this should
be in terms of the advantages and disadvantages of the different methods
employed. Finally, discuss any qualitative considerations that she may wish to
factor in her final decision. Remember to include appropriate references and
pay attention to the report’s presentation. The report should be 4 to 5 pages excluding title and reference page

Virtual Stock Exchange Project
You will be participating in a virtual stock exch

Virtual Stock Exchange Project
You will be participating in a virtual stock exchange! You will be buying and selling stock over the next 4 modules and analyzing the fluctuation in the value of your stock portfolio.
Registration
Register for the game as soon as you can. To register your account, go to:
http://www.marketwatch.com/game/YOURGAME*
*Your instructor will provide you with the name of YOURGAME for this term.
Game Password: PASSWORD*
*Your instructor will provide you with the password for this term.
Registration is free.
Constraints
You will be “given” $500,000 in fictional funds.
Each position you take in an asset must be a minimum of 5% of your assets and a maximum of 10% of your assets.
Cash must not exceed 20% of your portfolio at any time. We want you invested, not sitting on the sidelines.
Resources
Resources that you may find to be particularly valuable for your research include:
MarketWatch: http://www.marketwatch.com/
Wall Street Journal: www.wsj.com
Yahoo Finance: finance.yahoo.com
Daily Treasury Yield Curve Rates: http://www.treasury.gov/resource-center/data-chart-center/interest-rates/Pages/TextView.aspx?data=yield
Bloomberg: www.bloomberg.com
SLP Assignment
Make 3 stock purchases and provide information about the companies.
Please download the Module 1 SLP template. You will type your answer into this Excel workbook. When finished with the SLP assignment, please save the document with your last name and submit to the dropbox.
Purchase 1 through 3: Complete 3 stock purchases of your choice. Buy at least $10,000 worth of each stock. At least one of these stocks must pay a dividend. You are free to make additional purchases. Do not sell your required stock purchases yet.
Don’t worry, you don’t have to use any fancy methods to pick these stocks. The only restrictions are they need to be publicly traded companies with data available on webpages such as Investing.com or Morningstar.com or any of the other webpages mentioned in the directions. Your choice of companies can be made based on a variety of factors. For example, you may want to invest in a company simply because you like its products and personally use them. You can also apply some of the criteria from the background readings such as the P/E ratio, or you can search the internet and see what different analysts are saying about this company.
You will need to include the following information for each stock in this workbook:Company Name
Ticker Symbol
Short Description of Company
Reason for Buying
Current Price
Previous Close Price
52-week High
52-week Low
Beta
Market Cap
P/E Ratio
Pays a Dividend? (Yes or No)
The video below should help:
SLP Assignment Expectations
Answer the assignment questions directly.
Stay focused on the precise assignment questions. Do not go off on tangents or devote a lot of space to summarizing general background materials.
For computational problems, make sure to show your work and explain your steps.
For short answer/short essay questions, make sure to reference your sources of information with both a bibliography and in-text citations. Citation and reference style instructions are available at Trident University’s Introduction to APA Style, 7th edition
Another resource is the “Writing Style Guide,” which is found under “My Resources” in the TLC Portal.

You are a finance manager for a major utility company. Think about some of the c

You are a finance manager for a major utility company. Think about some of the capital budgeting techniques you might use for some upcoming projects.
Discuss at least 2 capital budgeting techniques and how your company can benefit from the use of these tools.

Calculate the financial ratios included in the table below for Banner Health fo

Calculate the financial ratios included in the table below for Banner Health for 2014 and 2015. Banner Health financial statements can be found in the attachment.RatioBenchmark
Total margin15.0%
Total asset turnover2.0
Equity multiplier1.67
Return on Equity (ROE)37.6%
Return on Assets (ROA)22.5%
Current Ratio2.0
Days cash on hand85 days
Average collection period20 days
Debt ratio40%
Debt-to-equity ratio0.67
Times interest earned (TIE) ratio5.0
Fixed asset turnover ratio1.4
DuPont Analysis37.6%
Answer the following questions: What is the overall financial condition of Banner Health?
What do the trends tell you about the financial performance of Banner Health?
How does the performance of Banner Health compare to the benchmarks provided?
What are two areas that could be improved that would result in improved performance?

As the new business manager working for the Chief Financial Officer (CFO) of you

As the new business manager working for the Chief Financial Officer (CFO) of your company, you want to review historical financial information to be fully informed of your company’s business valuation so you can provide guidance on near future financial decisions. You decide to put together a presentation on your company’s financial performance that assesses the cash flow, valuation, and KPIs for financial stability that you will present at the next management meeting. Your ultimate plan is to write a financial plan that will lead to future company growth.
Assessment Deliverable
Using General Motors, create an 8- to 10-slide presentation to assess the company’s financial growth and sustainability.
Identify 2 key performance indicators.
Relate the stock price to price-to-earnings ratio.
Explain the market capitalization and what it means to the investor.
Identify trends in stock price, dividend payout, and total stockholders’ equity. Relate recent events or market conditions to the trends you identified.
Determine, based on your analysis, whether you think the organization is going to meet its financial goals, describe the outlook for growth and sustainability, and explain why you do or do not recommend this stock for purchase and how your recommendation compares to that of other analysts. For example, if your suggestion is buy, you need to explain why other analysts say sell.
Cite references to support your assessment according to APA guidelines.

Using a case study to answer for questions on financial budeting and providing c

Using a case study to answer for questions on financial budeting and providing calculations (Payback, NPV, IRR etc.) to be done in excel and all work and formulas must be shown.
I have also attached an example from class.

PRESENT VALUE AND BOND VALUATION
Virtual Stock Exchange Project
Module 2 SLP Ass

PRESENT VALUE AND BOND VALUATION
Virtual Stock Exchange Project
Module 2 SLP Assignment
Make 3 stock purchases and provide information about the purchases
Please download the Module 2 SLP template. You will type your answer into this Excel workbook. When finished with the SLP assignment, please save the document with your last name and submit to the dropbox.
Purchase 4: Assume you are a very risk averse investor (you don’t like risk). Buy at least $10,000 worth of a company’s stock that is appropriate given your risk preference.
Purchase 5: Assume you are a very risk loving investor (you LOVE risk). Buy at least $10,000 worth of a company’s stock that is appropriate given your risk preference.
Purchase 6: Assume you are an investor willing to accept average market risk (the Beta of the stock should be around 1). Buy at least $10,000 worth of a company’s stock that is appropriate given your risk preference.
You are free to make additional purchases, but you only need to explain the reasoning behind your required purchases 4 through 6.
You will need to include the following information for each stock in this workbook:Company Name
Ticker Symbol
Reason for Buying
Current Price
Previous Close Price
52-week High
52-week Low
Beta
Market Cap
P/E Ratio
The following video should be helpful:
SLP Assignment Expectations
Answer the assignment questions directly.
Stay focused on the precise assignment questions. Do not go off on tangents or devote a lot of space to summarizing general background materials.
For computational problems, make sure to show your work and explain your steps.
For short answer/short essay questions, make sure to reference your sources of information with both a bibliography and in-text citations. Citation and reference style instructions are available at Trident University’s Introduction to APA Style, 7th edition . Another resource is the “Writing Style Guide,” which is found under “My Resources” in the TLC Portal.