ScenarioUsing spreadsheets to solve complex problems is a key competence – in fact a requirement – for many middle management positions in the workplace. Corporate finance provides many opportunities to use MS Excel to solve problems that cannot easily be solved manually. In this assignment, you will use MS Excel to prepare pro forma financial statements and also calculate free cash flow for a multi-year business opportunity. Whil...
TaskGeneral: You have recently started your own accounting firm and have been engaged by Wheelie Cool Bicycles (âWCBâ), which is a new business that commenced operations on April 1, 2020. WCB manufacturers a variety bicycles and sells them to local shops across Canada. One of the owners, who is the company spokesperson, has reached out to your firm for some assistance in preparing WCBâs an...
Task: Group project*: Please refer to the Form 10k 2020 annual report of Apple or Microsoft. You can print the annual report from the internet. Please perform the following and perform the following. Please attach the financial statements that you used Refer to the Management Discussion & Analysis section and write a one page summary describing the highlights of the year. Prepare a horizontal analysis of the 2020 and 2019 Income St...
Detail and discuss the 2019 FMA governance principles using three 2021 New Zealand Annual Reports of 3 companies of your choice. Evaluate how well the Board of Directors reports against these. https://www.fma.govt.nz/assets/Guidance/180228-Corporate-Governance-Handbook-2018.pdf (Hint, you might want to find examples that are not ideal then you can discuss weakness. It is suggested that the length be in the 1500 - 2000 word range. Your papers shou...
Identify your RoleIdentify your Role One of the first steps is to identify your role in the case. Are you an independent auditor? Part of a management team? An advisor? The role is important as it dictates various aspects of your analysis and response, including which user’s goals you try to accomplish and the tone/style of the report. Identify the Required Tasks Identify what exactly is being asked of you and be sure to address all of the...
Task 1 - Case study 1: Aotearoa InsuranceApply legal obligations in a financial advice situation. You must submit your work through the assignment submission link in the course. Upload your assignment, then use the âSaveâ and âSubmit assessmentâ buttons â or we will not receive your assignment. You will get an electronic receipt and your work i...
Module Learning Outcomes Being AssessedWhat is the purpose of this assessment? The following table shows which of the module learning outcomes are being assessed in this assignment. Use this table to help you see the connection between this assessment and your learning on the module. At the end of the project, students are expected to be able to: investigate and understand the range of inputs into a development appraisal; apply discoun...
QuestionsWe will be using the financial statement that is located on the Internet for the not for profit organization named Youth Without Shelter (YWS). The not for profit charity is located in the greater Toronto area. The financial statement is located on their public website (yws.on.ca) under the heading “who we are” and then “Financials”. I have also attached the financial statements to the assignment that are publi...
Revenue recognition The student will conduct a research project examining some aspect of financial accounting theory that is currently being debated in the accounting and business world. The topic for this assignment is Revenue recognition. You are required to search for journal articles in professional peer-reviewed accounting and business journals that pertain to your individual financial accounting theory topic. You are required write a paper ...
Motivations for Snap Inc.’s IPOThe assignment is based on the following documentsA case study: ‘Snap Inc.’s IPO’Snap Inc.’s IPO prospectusAn Excel file containing daily share price of Snap from its IPO toMarch 2020 (Snap shareprice) Snap’s Annual Report 2020 Read the above documents and the IPO book (e-copy available on Blackboard) to answer the following questions. You can use external references/material...
Calculating Treasury Bonds Prices and YieldBonds and Yield CurveDownload the data for the term structure of the US risk-free interest rates. Explain your choice.a) Calculate the prices of Treasury bonds with 5, 15, and 25 years until maturity. In each case, assume the face value of $100 and the coupon rate of 6% per annum and that coupons are paid annually. Assume continuous compounding. In case your interest rates dataset does not include a r...
Overview of the assigned caseServe as an analyst (a role that may also involves news reporter, detective, researcher, etc.), dig the information/stories behind the assigned case, and report your findings and analysis to the 4510 class, by applying what you have learned from the course. 1. Provided an overview of what is discussed in the assigned case (Use 5W1H: who, when, where, what, how) 2. Generate a list of questions you want to investig...
Case A: Performance and sustainabilityThe assignment considers an analysis of Britvic plc versus AG Barr plc. You are required to submit 2 reports: Case A examining the performance and sustainability of both companies AND Case B dealing with risk and return on equity of both companies. Case A carries 60% of the marks for the assignment and Case B carries 40% of marks for the assignment.There is an absolute word limit of 3,500 words (excluding...
Part 1 Rules and Evaluation Not to exceed 10 pages and is done as a group assignment. You will submit a financial proposal from a company for funding. For example, âWinpak is seeking a loan of $2.5 million at 5% annual interest to finance a $10 million transaction with F&N. You will write it from the perspective of the company, (you can write in third person) but include the âDecisionâ...
Crystal Gomez Case Study Crystal Gomez would like your help in revising her financial plan. Please answer the following questions after reviewing her financial and personal information. Financial Statement Analysis Using the income and expenditure information for 2019,complete a cash flow statement for Crystal Gomez. Date this statement January through December of 2019. Use the "cash flow" concept for this financial statement including al...