Excel template provided for assignment with 2 complete problems (one with income statement tab and other tab with balance sheet) Each one with a couple of bullets to complete in each. Please use template I provide. Professor states for first problem would use information from question PDF i provide and then copy exact statement and duplicate so that there is 2 (one for each year 2021 and 2022.). Please reach out with questions. Thanks
Category: Financial Management
-
“Analyzing Project Profitability: The Impact of Forecasting Errors Through Sensitivity, Scenario, and Break-Even Analyses”
Use sensitivity, scenario, and break-even analyses to see how project profitability would be affected by an error in your forecasts.
-
Title: Analyzing Cash Flow Statement of ExxonMobil: Dividend Payout Ratio
Cash Flow Statement Analysis
This week we turn to the last of the major financial statements – the Cash Flow Statement.
Note: We want to encourage a rich exchange of information and ideas in this discussion. Please select a Cash Flow Statement line item or ratio based on the first letter of your last name as indicated below.
Locate and post a screen shot of an actual Cash Flow Statement from the latest fiscal year for one of the following companies:
Medtronic
ExxonMobil
Your own Company (or any company you choose)
Pick a Cash Flow Statement line item or ratio from the following list:
Select from Here if Your Last Name
Starts with A-M
Line Item
Select from Here if Your Last Name
Starts with N-Z
Ratio
Net Change in Cash
Cash Flow from Operations
Cash Flow from Investing
Cash Flow from Financing
Capital Expenditures
Dividends Paid
Proceeds from Long Term Debt
Cash Flow Return on Assets
Dividend Payout Ratio
Cap Ex to Depreciation Ratio
Free Cash Flow
What does this line item or ratio measure and why is it important for Management to understand this number
From the Cash Flow Statement, identify the past 4 years of amounts for your line item or ratio. Share this data with the class using a data table or chart.
Answer the following questions:
What is the trend for this line item or ratio?
Has the line item or ratio amount increased or decreased?
Is this a “good” or a “bad” thing for this company?
What might management do to improve this line item or ratio? -
Understanding Options and Derivative Investments Title: Understanding Options and Derivative Investments Call options and put options are both types of financial contracts that give the holder the right, but not the obligation, to buy (call option) or sell (put option
Book used for class:
9th Edition Fundamentals of Futures and Options Markets by John c. Hull
Chapter 1 and 4
Suggested talking Points
Call options and put options
Options vs stock investments
Protective put
SOFR rate
Continuously Compounded Rate
Zero rate
Forward Rate
Forward Rate Agreement (FRA)
Submission Instructions:
Here is more about the requirement for your responses: You may use all your responses to focus on one talking point listed above. You may also use your responses to cover more than one topics. Discuss the meaning of these terms and how these topics impact derivative investment decisions. -
Cash Flows at East Coast Yachts: Analyzing Financial Performance and Expansion Plans
Instructions
CASH FLOWS AT EAST COAST YACHTS
Because of the dramatic growth at East Coast Yachts, Larissa decided that the company should be reorganized as a corporation. Time has passed and, today, the company is publicly traded under the ticker symbol “ECY”.
Dan Ervin was recently hired by East Coast Yachts to assist the company with its short-term financial planning and also to evaluate the company’s financial performance. Dan graduated from college five years ago with a finance degree, and he has been employed in the treasury department of a Fortune 500 company since then.
EAST COAST YACHTS
2017 Income Statement
Sales $611,582,000
Cost of goods sold 431,006,000
Selling, general, and administrative 73,085,700
Depreciation 19,958,400
EBIT $ 87,531,900
Interest expense 11,000,900
EBT $ 76,531,000
Taxes 30,612,400
Net income $ 45,918,600
Dividends 17,374,500
Retained earnings $ 28,544,100
The company’s past growth has been somewhat hectic, in part due to poor planning. In anticipation of future growth, Larissa has asked Dan to analyze the company’s cash flows. The company’s financial statements are prepared by an outside auditor. Nearby you will find the most recent income statement and the balance sheets for the past two years.
Larissa has also provided the following information. During the year, the company raised $40 million in new long-term debt and retired $22.6 million in long-term debt. The company also sold $24.2 million in new stock and repurchased $35.64 million. The company purchased $59.5 million in fixed assets, and sold $6,718,200 in fixed assets.
Larissa has asked Dan to prepare the financial statement of cash flows and the accounting statement of cash flows. She has also asked you to answer the following questions:
1. How would you describe East Coast Yachts’ cash flows?
2. Which cash flows statement more accurately describes the cash flows at the company?
3. In light of your previous answers, comment on Larissa’s expansion plans.
1 Bondholders are investors in the firm’s debt. They are creditors of the firm. In this discussion, the term bondholder means the same thing as creditor.
2 Confusion often arises because many financial accounting terms have the same meaning. This presents a problem with jargon for the reader of financial statements. For example, the following terms usually refer to the same thing: assets minus liabilities, net worth, stockholders’ equity, owners’ equity, book equity, and equity capitalization.
3 Generally, GAAP requires assets to be carried at the lower of cost or market value. In most instances, cost is lower than market value. However, in some cases when a fair market value can be readily determined, the assets have their value adjusted to the fair market value.
4 One situation in which taxable income may be lower than accounting income is when the firm uses accelerated depreciation expense procedures for the IRS but uses straight-line procedures allowed by GAAP for reporting purposes.
5 A firm’s current liabilities sometimes include short-term interest-bearing debt usually referred to as notes payable. However, financial analysts often distinguish between interest-bearing short-term debt and non-interest-bearing short-term debt (such as accounts payable). When this distinction is made, only non-interest-bearing short-term debt is usually included in the calculation of net working capital. This version of net working capital is called “operating” net working capital. The interest-bearing short-term debt is not forgotten but instead is included in cash flow from financing activities, and the interest is considered a return on capital.
6 New debt and the retirement of old debt are usually found in the “notes” to the balance sheet -
Title: Exploring the Impact of Social Media on Consumer Behavior: A Literature Review
This is a preparation exercise for a thesis. Proposal should include introduction and literature review. ALL REFERENCES MUST COME FROM HIGH LEVEL JOURNALS. The definition of high level is explained in the attached word file, as well as more detailed instructions on the assignment.
-
Introduction to Nike Inc. Nike Inc. is a multinational corporation that designs, develops, and sells athletic footwear, apparel, equipment, and accessories. The company was founded in 1964 by Bill Bowerman and Phil Knight and is headquartered in
Write a short paper that introduces the business you chose for your final project.
Specifically, you must address the following rubric criteria:
Business Selection: Select a company from the Final Project Business Options List and describe the business you chose, including the business name and what the business offers consumers.
Financial Statements: Using Mergent Online, look up the balance sheet, the income statement, and the cash flow statement for the latest fiscal quarter for the business you chose. Use these statements to accurately report the following values:
Total assets
Total liabilities
Current assets
Current liabilities
Net income
Shares outstanding
Earnings per share (EPS)
Total revenue
Shareholders’ equity
Financial Statement Role: Explain why financial statements are important to a business and how they help a business determine its financial health.
Cash Flow Management: Use a financial news story from the past two months as an example to explain why cash flow management is important to a business and its financial health.
What to Submit
Your submission should be a 4- to 5-paragraph Microsoft Word document with 12-point Times New Roman font, double spacing, and one-inch margins. All sources should be cited using APA style. Include the Balance Sheet and Income Statement from Mergent Online with your submission. -
Cross-Border Valuation and Synergy Management Analysis Title: “Analyzing Cross-Border Valuation and Synergy Management: A Case Study on XYZ Company”
You must perform Cross-Border Valuation and Synergy Management analysis. Use an Excel sheet to answer the Valuation question (Q#3) and Synergy Management Question (Q#2). Please keep your Excel sheet as organized as possible. I provided some Excel files both for Cross Border Valuation and Synergy management that you can use as your sample. Use formulas, list related data assumptions in a separate worksheet, and reference those data and assumptions in the DCF valuation sheet
-
Title: Understanding the Impact of Social Media on Mental Health: A Comprehensive Review
**Detail Instructions to paper are attached.
**Other instructions are to use APA format, double spaced, reference page, 6 references with at least 3 scholarly peer reviewed journals and all references cited within text. -
“Researching Company Information: A Comprehensive Guide”
All documents are attached. Please let me know ASAP if you need anything to complete the assignment. Thank you in advance for all your help. https://youtu.be/20sir4ecM34?si=1MqHhH5IHNc8y9l-
https://bellevue.libwizard.com/f/companyinfo