Choose an industrial company (not a financial institution or an insurance company) whose stock trades on the NYSE, the

Choose an industrial company (not a financial institution or an insurance company) whose stock trades on the NYSE, the AMEX, or the OTC for which you can obtain the most recent Annual Report (2018’s or 2017’s if 2018’s is not available). The annual reports of most of the publicly traded companies are available online on the company’s website. You can get the report by calling the company’s office of investor relations. There are other sources for a free copy of companies’ annual report. Go online for this. Please make sure that it is an annual (as opposed to a quarterly) report. Since some reports are subject to availability, you may want to choose two or three different companies in the beginning.

Go online to http://finance.yahoo.com (Links to an external site.) and locate the firm. Select and print out the Company Profile (should include a phone number that can be called to request an annual report), Key Statistics, and analyst opinion. Alternatively, you can get the Company Profile from different sources.

Additionally, search online to find at least two of the most recent articles concerning your firm. If you cannot locate at least two articles about the firm, choose another firm.

Using information from these sources, do the following (all written responses are to be typed, double spaced, and all charts should be generated by a spreadsheet program, such as MicroSoft Excel):

Write a 1-2 paragraph descriiption of the company, defining its main line of business and listing all secondary lines of business and/or subsidiaries.

Write a 2-3 page summary of the recent articles concerning your firm.

Final Proposal Read the Chapter 18 Mini Case 1: Dorchester, Ltd. Using the material developed for Weeks 1 through

Final Proposal
Read the Chapter 18 Mini Case 1: Dorchester, Ltd. Using the material developed for Weeks 1 through 5, write a fifteen to twenty page proposal to Dorchester, Ltd.’s management team. In your proposal, advise them of an acquisition target based on research previously conducted. Your proposal should also include:

An economic assessment of the country chosen,
A risk mitigation plan,
A financing plan on how to finance the acquisition, and
A concluding recommendation using supporting rationale derived from the above mentioned items.
Use non-course materials to support your contentions and incorporate pro forma financial statements and supporting documentation to support your proposal.

The proposal

Must be fifteen to twenty double-spaced pages in length and formatted according to APA style as outlined in the Writing Center (Links to an external site.).
Must include a separate title page with the following:
Title of proposal
Student’s name
Course name and number
Instructor’s name
Date submitted
Must begin with an introductory paragraph that has a succinct thesis statement.
Must address the topic of the paper with critical thought.
Must end with a conclusion that reaffirms your thesis.
Must use at least five scholarly sources, including a minimum of two from ProQuest.
Must document all sources in APA style as outlined in the Writing Center.
Must include a separate references page that is formatted according to APA style as outlined in the Writing Center.

Writing Assignment 1 (with Excel work): Financial Ratio Analysis Your submission should be a one-page executive summary of what

Writing Assignment 1 (with Excel work): Financial Ratio Analysis
Your submission should be a one-page executive summary of what you found in your analysis with two external citations and a copy of the Microsoft Excel spreadsheet that you used to complete your analysis. Graphs and figures should be presented as appendices (i.e., not presented within the body of the executive summary).

Income Statement Analysis This week’s DQ focuses on the Income Statement. It builds on the insights we gained in

Income Statement Analysis
This week’s DQ focuses on the Income Statement. It builds on the insights we gained in Week 2, but goes a little deeper in our use of financial statement analysis skills.
Locate and post a screen shot of an actual Income Statement from the latest fiscal year for one of the following companies:
Sears (Note: use this link Sears Holding Corp 10-K)
Tesla
Pick an Income Statement Line Item or Ratio from the list below:
Line Item
Ratio

Revenue (aka Sales, Turnover)
Cost of Goods Sold/Cost of Sales
Salary Expense
Selling, General and Administrative Expense
Gross Profit
Operating Profit
Net Profit

Gross Margin (%)
Net Margin (%)
Salary Expense as % of Sales
Return on Sales
Return on Equity
Return on Assets
Earnings Per Share (EPS)
EBITDA

What does this line item or ratio measure and why is it important item for Management to understand this number?
Identify the past 4 years of amounts for your line item or ratio (Note: this will require you to track down additional historical Income Statements to get the older data). 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” thing or a “bad” thing? For this company?
What might management do to improve this line item or ratio?

About this Assignment Building a portfolio by using a combination of instruments with maximum returns and just the right

About this Assignment
Building a portfolio by using a combination of instruments with maximum returns and just the right amount of risk is key to successful investing. In this course, you have learned about types of financial markets and investments, short-term and long-term investment goals, and portfolio management.

For this assignment, you will select one prompt from the list below and write a 2,000-word analysis and investment strategy proposal. The paper must be double-spaced in APA format with Times New Roman size 12 font.

Prompt
Select one of the following prompts for your assignment. Research the required topics and use what you have learned in the course to create your analysis and investment strategy proposal.

1. Alice is a retired 75-year-old who has $500,000 after selling her small business and paying taxes on the sale. She wants to invest this money. Alice would like the capital to rise faster than inflation to maintain the purchasing power of her wealth. However, she would also like to make low-risk investments and have easy access to at least $50,000 per year for the next five years.

2. Andy and Sam are both 45 years old. They have two main financial goals: saving for retirement and saving for their eight-year-old daughter’s college education. Sam recently inherited money from his aunt, and after taxes, has $400,000. Andy and Sam would like to aggressively invest this inheritance and an additional $1,000 each month from their combined incomes in hopes of achieving maximum return. Andy and Sam want to retire 20 years from now, and their daughter will need to begin drawing money from the college fund in 10 years.

3. Sasha is 32 years old. She just won the lottery and decided to take a lump sum payment. After paying taxes, she has $2.4 million left. Sasha wants to immediately spend $500,000 and invest the rest. She doesn’t want to aggressively risk her money, but she does want to maximize her return so that she can quit her job now and live the most lavish lifestyle that she can afford for the rest of her life.
No matter which prompt you select, your analysis and investment strategy proposal should:

Explain in general how stocks, bonds, funds, futures, debts, and other investment instruments are traded in financial markets.
Analyze investment opportunities that align with the financial goals of the scenario.
Recommend specific investments to create a portfolio from the available capital.
Evaluate the risks of the recommended investments and the impact that diversification, taxes, inflation, and currency fluctuation could have on the proposed portfolio.
Calculate projected rates of return on each item in the proposed investment portfolio
Recommend strategies for long-term and short-term investment; include justifications for the recommendations you make.

Using Sources
You may refer to the course material for supporting evidence, but you must also use 3 sources and cite them using APA format. Please include a mix of both primary and secondary sources, with at least one source from a scholarly peer-reviewed journal.

Primary sources are first-hand accounts such as interviews, advertisements, speeches, company documents, statements, and press releases published by the company in question.
Secondary sources come from peer-reviewed scholarly journals, such as the Journal of Finance. You may use sources like JSTOR, Google Scholar, and OMICS International to find articles from these journals. Secondary sources may also come from reputable websites with .gov, .edu, or .org in the domain. (Wikipedia is not a reputable source, though the sources listed in Wikipedia articles may be acceptable.)

Finance Question

To complete the assignment, please download the Excel file Week 2 Categorical Data.xlsx. Use this Excel file as a template to work with the data in the file.
The highlighted yellow areas are for you to put in your work. You will be graded by the work you have done following the given instructions in the Excel file.

Mini Case 7 Presentation Assessment Descriiption This is a Collaborative Learning Community (CLC) assignment. The purpose of this assignment Essay

Mini Case 7 Presentation
Assessment Descriiption
This is a Collaborative Learning Community (CLC) assignment.
The purpose of this assignment is to explain core concepts related to stock, equity, debt, and the roles they play in making tactical financial decisions.
Read the Chapter 20 Mini Case in Financial Management: Theory and Practice. Using complete sentences and academic vocabulary, please answer questions a and b.
Mini Case 7 Ch. 20 from textbook:
Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets. Although EduSoft has done well, the firm’s founder believes an industry shakeout is imminent. To survive, EduSoft must grab market share now, and this will require a large infusion of new capital.
Because he expects earnings to continue rising sharply and looks for the stock price to follow suit, Mr. Duncan does not think it would be wise to issue new common stock at this time. On the other hand, interest rates are currently high by historical standards, and the firm’s B rating means that interest payments on a new debt issue would be prohibitive. Thus, he has narrowed his choice of financing alternatives to (1) preferred stock, (2) bonds with warrants, or (3) convertible bonds.As Duncan’s assistant, you have been asked to help in the decision process by an-swering the following questions.
A. How does preferred stock differ from both common equity and debt? Is preferred stock more risky than common stock? What is floating rate preferred stock?
B. How can knowledge of call options help a financial manager to better understand warrants and convertibles?

Mini Case 8
The purpose of this assignment is to explain core concepts related to lease vs. purchase and tactical financial decisions.
Read the Chapter 19 Mini Case in Financial Management: Theory and Practice. Using complete sentences and academic vocabulary, please answer questions a through f.
Mini Case 8 Ch. 19 from textbook:
Lewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by the firm’s brokers. The system also permits customers to call up current quotes on terminals in the lobby. The equipment costs $1,000,000 and, if it were purchased, Lewis could obtain a term loan for the full purchase price at a 10% interest rate. Although the equipment has a6-year useful life, it is classified as a special-purpose computer and therefore falls into the MACRS 3-year class. If the system were purchased, a 4-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after 4 years, and the best estimate of its residual value is $200,000. However, because real-time display system technology is changing rapidly, the actual residual value is uncertain. As an alternative to the borrow-and-buy plan, the equipment manufacturer informed Lewis that Consolidated Leasing would be willing to write a 4-year guideline lease on the equipment, including maintenance, for payments of $260,000 at the beginning of each year. Lewis’s marginal federal-plus-state tax rate is 25%. You have been asked to analyze the lease-versus-purchase decision and, in the process, to answer the following questions.
A. Questions to answer:
(1) Who are the two parties to a lease transaction?
(2) What are the four primary types of leases, and what are their characteristics?
(3) How are leases classified for tax purposes?
(4) What effect does leasing have on a firm’s balance sheet?
(5) What effect does leasing have on a firm’s capital structure?

B. Questions to answer:
(1) What is the present value of owning the equipment? (Hint: Set up a time line that shows the net cash flows over the period t 5 0 to t 5 4, and then find the PV of these net cash flows, or the PV of owning.)
(2) What is the discount rate for the cash flows of owning?
C. What is Lewis’s present value of leasing the equipment? (Hint: Again, construct a time line.)
D. What is the net advantage to leasing (NAL)? Does your analysis indicate that Lewis should buy or lease the equipment? Explain.
E. Now assume that the equipment’s residual value could be as low as $0 or as high as $400,000, but $200,000 is the expected value. Because the residual value is riskier than the other relevant cash flows, this differential risk should be incorporated into the analysis. Describe how this could be accomplished. (No calculations are necessary but explain how you would modify the analysis if calculations were required.) What effect would the residual value’s increased uncertainty have on Lewis’ lease-versus-purchase decision?
F. The lessee compares the present value of owning the equipment with the present value of leasing it. Now put yourself in the lessor’s shoes. In a few sentences, how should you analyze the decision to write or not to write the lease?

(word doc attached as well for reference

Finance Question

S
Compute each of the following ratios for 2019 and 2020 and
indicate whether each ratio was getting “better” or “worse” from 2019 to 2020
and was “good” or “bad” compared to the Industry Avg in 2020
(round all numbers to 2 digits past the decimal place)

SEE WORD AND EXCEL SHEET, THANKS

Problem set using 2 methods: pricing formulas and Excel

Homework 1

READ BEFORE YOU START: Solve each of the following question using 2 methods: pricing formulas and Excel. When calculating using the pricing formula (e.g., Price of perpetuity P = C/r), please write the original formula and the steps where you plug in the number for each variable, and your final answers. When solving it using Excel, copy your functions in the solution (e.g., =PV(0.5,10,0,-1000).
1. If you wish to accumulate $150,000 in 10 years, how much must you deposit today in a bank account that pays an annual interest rate of 12%?
2. A zero-coupon bond has a face value of $21,000 and a maturity of 8 years. Similar bonds have an interest rate of 5% per year. What is the price of this bond?
3. You plan to retire in 35 years. At the end of each year, you plan on saving $15,000, and your bank pays you 2% annual interest. How much will you have saved by the time you retire?
4. A bond with a face value of $1,000 pays a 10% (APR) semiannual coupon and matures in 10 years. Similar bonds trade at a YTM of 8% (APR). What is the price of the bond?
5. You are managing a small company and need to buy some equipment for your product line. Kangaroo Manufacturing is offering free credit on a $20,000 piece of equipment. You pay down $2,000 and then $600 a month for the next 30 months. Turtle Machines does not offer free credit but will give you a $2,000 off the list price. If the rate of interest is 10% (APR) a year, which company is offering a better deal?
6. Mathematically derive the annuity formula: . Hint: Think about a geometric sequence which is defined as a list of numbers: , where both x and k are constants. The sum of a geometric sequence equals .

Problem set

Problem Set #1(Chapters 1-3)
Problem Set #1 contains Questions and Problems from Chapters 1-3. The Questions and Problems can be found at the end of each chapter in the Problem Sets section and are due by Tuesday January 18, 2022, via the eLearn Assignments folder. You may work with a partner (maximum of 2 students per group). If you work with a partner, choose one member to turn in one copy of the assignment to represent the team (Don’t forget to include BOTH members’ names on the first page). The Problem Set may be typed or NEATLY handwritten. Each Question or Problem is worth two points and partial credit is also possible. Finally, make sure to show all work for the solutions.
Here they are…
Chapter 1: #9, #10 a. and b., and #21 (Page 24 and 25)
Chapter 2: #13, #14, #15, #18, #19 (Use Example 2.2 on page 42 for inspiration) (Page 50)
Chapter 3: #17 and #21 (Page 81 and 82)