Write a brief journal introducing the business you chose for your Project Two assignment.
Specifically, you must address the following rubric criteria:
Business Selection: Provide a descriiption of the business you chose, including the business name and what it offers consumers.
Financial Statements: Using Mergent Online, provide a copy of the balance sheet, the income statement, and the cash flow statement for your chosen business from the most recent fiscal quarter.
Financial Statement Role: Explain why financial statements are important to a business and how they help businesses determine their current financial health.
Cash Flow Management: Describe why cash flow management is important to a business and its financial health. Use a recent financial news story as an example to support your claims.
Guidelines for Submission
Your journal submission should be a 3- to 4-paragraph Word document with 12-point Times New Roman font, double spacing, and one-inch margins. Any sources should be cited according to APA style. You will also need to submit the Excel files for your chosen business’s balance sheet, income statement, and cash flow statement from Mergent Online.
3. Forecast cash flows per subscriber for the next 5 years. What is the value of a new subscriber using a discount rate of 20%. Consider possible outcomes and the probabilities associated with them. Based on your analysis, should NetFlix be acquiring new subscribers?
4. In March 2000, NetFlix had 155,000 total subscribers. Based on this number and forecast future growth rate, aggregate per subscriber cash flows. Assuming that NetFlix does not change its business model, come up with projected annual cash flows and a total value of NetFlix.com. Will NetFlix generate enough near‐term to have a successful IPO? How much cash does NetFlix need in order to remain viable?
5. What changes, if any, would you suggest to its business model? What are the value and cash flow implications of these changes?
Journal Entry – Accounting Ms Novelty Ice-cream was started by Raman Sharma who conducted the following transaction in the next ten days. Help Raman in preparing a journal entry Note: (pick from the multiple choice and explain Which one is Debit and Which one is Credit)
• He invested an amount of Rs 100,000 cash in the business on 01/04/2019. o Out of the total invested, he keeps Rs 25,000 cash and rest Rs75,000 is deposit in the Bank account 04/04/2019
• He purchased ice-cream making machine for Rs35,000 and paid cheque on 06/04/2019 • Raw material was purchased for Rs 3,000 on 09/04/2019
• He Sold ice-cream for Rs 5,200 on 10/04/2019 Question 1. The following accounts are involved in the transaction done on 09/04/2019 (pick from the multiple choice and explain Which one is Debit and Which one is Credit) A) Cash and Purchase Account B) Purchase and Raw Material Account C) Cash and Sales Account D) Cash and Business Account Question 2. The following accounts are involved in the transaction done on 01/04/2019 (pick from the multiple choice and explain Which one is Debit and Which one is Credit) A) Cash and Business Account B) Cash and Capital Account C) Capital and Business Account D) None of the above Question 3. The following accounts are involved in the transaction done on 10/04/2019 (pick from the multiple choice and explain Which one is Debit and Which one is Credit) A) Cash and Ice-Cream account B) Bank and Sales Account
C) Cash and Sales Account
D) Cash and Raman’s Account Question 4. The following accounts are involved in the transaction done on 6/04/2019 (pick from the multiple choice and explain Which one is Debit and Which one is Credit) A) Cash and Machinery Account B) Cheque and Machinery Account C) Cash and Cheque Account D) Machinery and Bank Account Question 5. The following accounts are involved in the transaction done on 04/04/2019 (pick from the multiple choice and explain Which one is Debit and Which one is Credit) A) Bank and Capital Account B) Cash and Capital Account C) Cash and Bank Account D) Bank and Business Account Time Value of Money
You have been hired as a financial advisor to Mr Sam. He has received two offers for playing for IPL and wants to select the best offer, based on consideration of money only. What will be your advice? (Hint: Compare the Present Value of each offer by assuming a range of interest, say 8% – 14%)
Note: Please show the formula and calculation for the answer selected Offer: A) Offer A is a $10million offer for $2million a year for 5 years B) Offer B is a $11million offer of $1million a year for four years and $7million in year 5th
Question 1. What is the difference between PV Value (Present Values) of offer A and B at 12%? A) $0.1 million
B) $0.2 million
C) $0.7 million
D) $0.8 Million Question 2. At 8% interest rate what would be the PV (Present Value) for Offer A
A) $8.1 Million
B) $8.4 Million
C) $8.3 Million
D) $7.9 Million Question 3. At 10% interest rate what would be the PV (Present Value) for Offer B
A) $7.5 Million
B) $8.1 Million
C) $8.9 Million
D) $8.5 Million Question 4. At 14% interest rate what would be the PV (Present Value) for Offer B
A) $6.5 Million
B) $8.2 Million
C) $8.3 Million
D) $8.5 Million Question 5. What is the difference between PV values (Present Values) of offer A and Offer B at 10%?
A) $0.05 Million
B) $0.06 Million
C) $0.07 Million
D) $0.08 Million
A strong opening statement that makes clear why I am applying for the job.
Include an accomplishment that shows address the challenges the employer is facing.
Use clear, concise language and keep succinct.
Avoid overly long sentences.
Tailor the cover letter to the job being applied for – job ad and position description attached.
Keep the letter to around 350 words on a single page – you can gauge based on your experience.
Attached is a sample cover letter, resume, job advertisement and position description for the job.
An aesthetically appealing, functional resume. Ideally 3 pages max. due to senior experience.
Professional font, such as Cambria, Calibri, Georgia, or Verdana. 11pt to 12pt size.
Single line spacing.
1-inch margins on all four sides.
Lots of white space to give readers some breathing room.
Big section headings.
Includes a professional summary, work experience, education, skills, and extra sections.
Follows a standard format: reverse-chronological, functional, or combination.
Attached is the current resume to use as a reference.
watch Identifying Business Risk—Risk Management Series https://www.youtube.com/watch?v=cZwyIPGhF_U
To participate in this discussion forum, select an annual report (10k) from a global company from either EDGAR Company Filings (Links to an external site.) or Yahoo! Finance (Links to an external site.). Additionally, learn how to quickly research a company’s operations and financial information by reviewing the Using EDGAR to Research Investments (Links to an external site.) web page.
Review the current financial statements of the selected company through Yahoo! Finance (Links to an external site.) or EDGAR Company Filings (Links to an external site.) database in the Filings and Forms page. FreeEDGAR (Links to an external site.) is also a convenient source for real annual and quarterly reports (called 10-Ks and 10-Qs within EDGAR Speak). You may prefer the SEC’s original EDGAR Company Filings (Links to an external site.), which is a little less user-friendly, but does not require registration. Yahoo! Finance (Links to an external site.) has summaries of annual and quarterly reports, plus key ratios, and much more. You can access the financial statements by going to the Yahoo! Finance (Links to an external site.) website, typing in the company name in the top search bar, and then clicking on the “Financials” tab.
Using the annual report from a company that you select, discuss the risks the company faces and the actions they take to mitigate those risks. Refer to the “management discussion and analysis” section of the annual report for this information. As part of your response, consider whether you think the risk mitigation techniques are reasonable. Discuss what other concerns or advice you would offer if you had the opportunity.
The topic I chose was Cardiology
For Part 1 of your assignment, you wrote a recommendation memorandum to the CEO and Senior Vice Presidents, providing a formal evidence-based recommendation for your selected programmatic service or enhancement, along with a formal request for organizational support.
Let’s assume that the MHS leadership has given you the authority to move forward with your selected service or programmatic enhancement. This week, in Part 2 of your finance project, you will apply all you have been learning this term to write a capital budget. Be sure to review the financial statements found in the MHS case study. Complete every component of the capital budget and ensure your proposed budget fits well within the MHS budget information provided.
Capital Budget Process:
Identify the desired goal and alternatives.
Identify and briefly explain sunk and opportunity costs considered in your capital budget decisions.
Explain your budget and decisions once your spreadsheet for your Capital Budget is completed.
Reintroduce the service/unit you are recommending in no more than 1-2 sentences. Then provide a 2-3 paragraph budget narrative to justify the budgeting decisions you made.
In an Excel Spreadsheet:
Set up a Capital Budget for your selected service or programmatic enhancement. You must include all of the following elements in your budget. To ensure success, go through these methodically one at a time. If you have questions, contact me or post a question in the discussion for the entire class.
Estimate output, output prices, and revenues, including when cash will be received.
Identify the type and quantity of resources needed, input prices, and when expenses will be paid.
Select a discount rate. See your FAQ’s and module notes for your options. Specifically, you will decide which discount rate to use based on what you know about the MHS case and the programmatic service/enhancement you are proposing.
Once you have chosen your discount rate, calculate the PV of future cash flows using an Excel spreadsheet. Do your calculations in a new tab in the current sheet and then input the number into your budget. This way I can provide guidance on your work.
Select an evaluation measure – either the NPV or the IRR – to assess cash flows. Chart the results on the budget Excel worksheet.
Conduct sensitivity analysis using the same Excel spreadsheet. Chart the results.
Use of formal APA is required for this assignment. At a minimum, you will be citing 1-2 sources within your budget narrative.
Task 8 – Financial Literacy
1. Sign up to Get Sorted https://sorted.org.nz/ and work your way through the following guides.
2. Next, complete the following quiz/planning activities to extend your understanding about financial literacy.
Money Personality Quiz – https://sorted.org.nz/tools/money-personality-quiz
Goal Planner – https://sorted.org.nz/tools/goal-planner/welcome
Budgeting Tool – https://sorted.org.nz/tool/budgeting-tool#/welcome
Retirement Planning – https://sorted.org.nz/tools/retirement-planner
3. After completing these activities, describe one thing you learnt from each of these quiz/planning activity about financial planning (identify the resource in your answer please).
4. Provide a brief but detailed account (max 300 words) about how financial planning aligns with/relates to your Life Mission (as submitted in Task 5).
Data Analysis Report Instructions
Familiarize yourself with the excel spreadsheet I’ve attached with the raw data.
Make a report addressing the following;
• Interpret the data and write multiple paragraphs on,
o What kind of data is available?
o What can it be used for and why?
o What is the purpose of each column and row?
• Make a list of 10 questions that could be answered by utilizing the data set
• Fully discuss the details of this data set
o Fully discuss in detail the results of 2018 and 2019 individually
o Then compare between 2018 and 2019 that are related to
▪ Monthly sales overview
▪ How have sales developed in 2019 compared to the year before in 2018?
▪ Top 10 customers, what changes can be noted?
▪ Top 10 products, what changes can be noted?
▪ 8 product categories, what changes can be noted?
▪ Top 10 regions, what changes can be noted? Have shifts occurred?
▪ What else might be helpful to know?
o Include recommendations and suggestions in your report
If you have any questions, feel free to reach out.
I’m attaching a copy of the data form and a copy of instructions.
Good evening, attached is an Excel Sheet with 2 Tabs which includes questions based on the math. Additional I need following below ( i also attached it on Word document)
Financial Decision Making for Managers
Step 1: Make Cost of Capital Decisions
Working in this Project 5 McCormick Workbook that Elisa has provided, complete the Cost of Capital worksheet. The Cost of Capital worksheet contains information about weight of equity and debt, cost of equity and debt, and the weighted average cost of capital, as well as questions that will help the client in selecting the best financing decision.
Step 2: Make Capital Budgeting Decisions
McCormick & Company will also need assistance in understanding how their anticipated growth, debt, market return, and marginal tax rate will affect their bottom line if they choose to pursue this new project.
Recalling what you have learned in the previous project about the time value of money and present value, you will also need to be knowledgeable about the ROE, ROA, and the DuPont Equations well as valuation of multiple cash flows to help McCormick make the decision on the project.
Working with the same Project 5 Excel Workbook you will use in Step 1, complete the Capital Budgeting worksheet. This worksheet contains additional information on the data that will drive McCormick’s investment decision—whether or not to build a new plant and purchase equipment.
Step 3: Discuss Capital Budgeting
In 250 Words Elisa has asked the finance team to meet and discuss how capital budgeting will influence McCormick’s investment decision. Complete the following tasks within your group:
Discuss the best estimates of McCormick & Company’s capital structure used for the acquisition of new product lines. Give credit to any sources you use to support your statements.
Discuss how understanding capital budgeting will impact the decision of McCormick and Company’s potential investment in a new factory. Give credit to any sources you use to support your statements.
Later in the week, after you are back in your office, you have a follow-up discussion with your MCS colleagues in an effort to summarize the key lessons from your discussion on capital budgeting at the meeting. Respond to your colleagues’ original discussion posts and give credit to any sources you use to support your statements.
Step 4: Prepare Executive Summary
Now that you’re concluding your project for McCormick & Company, please prepare an executive summary based on your analysis and recommendations from the previous steps. This executive summary, along with citations for any sources you use, should be about one page in length.
Within your executive summary, I’d like you to highlight your analysis and recommendations to help McCormick & Company identify areas of improvement in their operations and explore options to make cost of capital decisions based on capital budgeting.