Calculate the financial ratios for the actual three years

Assignment Help Finance Basics
Reference no: EM132158876

Prepare Financial Forecasts and Projections Case Study Assignment -

Case Study - Financial Forecasts

Undertake your own research to obtain an organisation's LATEST THREEYEAR annual reports. You can use one from an organisation with which you are familiar or one which is freely available on the internet (company's website) or from ASIC or ASX.

You are the Financial Planning and Analysis manager of the company you are choosing. In order to invest a project, the company is planning to apply for a loan from the bank. You was assigned by the CEO the task of advising the Board of Directors about the financial forecasts and the company's ability to meet the long-term obligations.

The proposed loan details are shown as below:

Proposed Loan Details

Loan Amount

$5,000,000

Loan term

4 years

Interest rate

6.50%

Payment frequency

Monthly

Required:

1. You are required to undertake your own research from the company's website, and read all the relevant information from the annual reports to understand and identify the organisational policy and procedures in regards to (not limited to) sales, inventory management, collection policy, credit, purchasing and payment policy and cost structures.

2. Calculate the financial ratios for the actual three years by using the following template. You can calculate the relevant ratios based on a year-end balance instead of the average beginning and ending year balance.

3. Briefly comment the profitability, liquidity and solvency of the company based on the financial ratios you calculated in the Part 2.

4. You are required to identify timeframes and parameters to be used for the financial forecasts.

5. You are required to use the EXCEL to include all the parameters or assumptions (i.e. key forecast drivers) used, and prepare proforma income statement and balance sheet.

6. You are required to forecast the free cash flow for the company.

7. You are required to write a REPORT (refer to Notes to the Students for more information) to include all the information and workings used in the preparation of proforma income statement and balance sheet, and free cash flow forecast.

Attachment:- Assignment File.rar

Reference no: EM132158876

Questions Cloud

What are unobservable concepts : What i don't get is what are these unobservable concepts, why are they unobservable and how may they be wrong at times.
Create a library of fund summaries on the managed funds : FINM7403 Portfolio Management Case Study Assignment - Hyperion Australian Growth Companies Fund. Create a library of Fund summaries on the managed funds
Enhance an individual''s performance : Make sure you explain all the elements of the concept of self-fulfilling prophecy.
Obtain the firm short-run production function : Production function: Q=f(L,K)=LsqrtK. Supposed that the firm operates in the short run with 16 units of capital.
Calculate the financial ratios for the actual three years : FNSORG506 Prepare Financial Forecasts and Projections Case Study Assignment - Calculate the financial ratios for the actual three years
Managers above-market wages : Why do you think a firm would pay its managers above-market wages?
Best represent producer-producer rivalry : Does this situation best represent producer-producer rivalry, consumer-consumer rivalry, or consumer-producer rivalry? Explain.
Way for banks to reduce liquidity risks : Holding excess reserves is one way for banks to reduce liquidity risks. Explain would banks be reluctant to hold too much in excess reserves--what is the tradeo
Firms in the industry : Suppose that we are still in the long run. What is the number of firms in the industry, rounding to the nearest integer?

Reviews

len2158876

11/3/2018 4:01:23 AM

Instructions - Assessments should be completed as per your trainer’s instructions. Assessments must be submitted by the due date to avoid a late submission penalty. You must write your answers in your own words or appropriately reference your sources. A list of references must be included. You may discuss your assessments with other students, but submitting identical answers to other students will result in a failing grade. Your answers must be yours alone. Your trainer will advise whether the assessment should be digitally uploaded or submitted in hard copy. Assessments that are digitally uploaded should be saved in pdf format. You must pass both assessments in the subject to pass the subject.

len2158876

11/3/2018 4:01:17 AM

Notes to the Students: You can use linear trend function to prepare the financial forecast, but keep in mind that the assumptions should be reasonable by cross checking with the organisational policy and procedures. Use the percentage of sales method to forecast the accounts in the income statement and T-accounts or ratios method to forecast the accounts in the balance sheets. You can group the operating expenses but have to make sure the key accounts (e.g. depreciation, net interest expenses and tax) should be separately disclosed in the proforma financial statements.

len2158876

11/3/2018 4:01:10 AM

Use the short-term debt or debts as the plug (the last account used to balance the balance sheet). You are required to submit the EXCEL to include: Financial ratios for the actual three years; Assumptions used in the financial forecasts for all the accounts; Proforma income statement and balance sheet (including the amounts in the three actual years); Free cash flow forecasts. You are required to submit the report in the WORD to include: Timeframes of your financial forecasts and reason; Organisational policy and procedures; Formulae used to work out the relevant ratios; Briefly comment the profitability, liquidity and solvency of the company based on the financial ratios you calculated;

len2158876

11/3/2018 4:01:04 AM

All the information and workings used for your financial forecasts in the EXCEL; Identify the relevant person in charge to obtain approval; Your opinion about whether the company has the ability to meet its longterm obligations if the company is about to apply for the loan. You can use the following templates for your work. Note that the accounts and amounts shown in the templates are EXAMPLE ONLY.

Write a Review

Finance Basics Questions & Answers

  The most recent financial statement for zoso inc are shown

the most recent financial statement for zoso inc. are shown here assuming no income taxesincome statementbalance

  What is the net asset value of an investment company

What is the net asset value of an investment company with $ 10,000,000 in assets, $ 790,000 in current liabilities, and 1,200,000 shares outstanding?

  What is the company breakeven point

A company's fixed operating costs are $630,000, its variable costs are $2.55 per unit, and the product's sales price is $5.85. What is the company's breakeven point; that is, at what unit sales volume will its income equal its costs? Round your an..

  What trades must the investor make now in order to return

What trades must the investor make now in order to return to an equally-weighted portfolio?

  What is the 95 percent probability range

A stock has returns of 3 percent, 17 percent, -24 percent, and 16 percent for the past 4 years. Based on this information, what is the 95 percent probability?

  What are investors concerned about

Why do you think that this is the case? What are investors concerned about? What would happen in financial markets if investors thought that there was a much higher probability than before that a recession would occur soon?

  How much does the firm expect to collect in may

Mark Anderson's Legal Aid has the following estimated revenue. Feb $16,400. Mar $14,800. Apr $17,900. May $17,500. Assume each month has 30 days and the accounts receivable period is 60 days. How much does the firm expect to collect in May?

  Question regarding the manufacturing budget analysis

Tom Emory and Jim Morris strolled back to their plant from the administrative offices of Ferguson & Son Manufacturing Company. Tom is manager of the machine shop in the company's factory; Jim is manager of the equipment maintenance department.

  Differences between merchandisers and manufacturers

What are the differences between merchandisers and manufacturers?- Describe the types of inventories used by manufacturers and merchandisers.

  What is the optimal sharpe ratio in a portfolio

What is the optimal Sharpe ratio in a portfolio of the two assets? What is the smallest expected loss for this portfolio over the coming year with a probability of 2.5 percent?

  What is the portfolio expected return and the portfolio

1 use the following information to answer the questions below.securitynbspnbspnbspnbspnbsp

  The operations management team evaluated ranked and

the operations management team evaluated ranked and recommended a set of capital projects using evaluation tools such

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd