Cash Flow Statement(Mil.$), Profit And Loss Account, Balance Sheet Data, Global Case Study - Accounting Assignment Help

Assignment Task -                 
 

Global Case Study
In order to succeed on the course FM, as stated in the Syllabus, it is necessary to make a  Global Case Study in the form of a financial model in excel. The goal is to apply in practice the financial tools you have learned in FM lectures. It is a specific task whose solution makes it possible to understand and manage corporate finance. 
Global Case Study: FINANCIAL MODEL 
Objective: To create an excel financial model associated with formulas from accounting to cash flow to Valuate the company, to calculate CF, FCF, optimal capital structure, and to determine the risk of investment (CAPEX) using different techniques for measuring investment profitability. You will have a company with its financial forecasts in excel with a possibility to do scenario or sensitivity analysis.
Page 1 (Pro forma): Make a page where you have 3 last years (Year N, Year N-1, Year N-2) : Balance sheet data, Income statement (P&L), and Cash flow statement.
Page 3 (Amortization): Make an Amortization calculating page for all your assets including the new CAPEX annually and cumulatively with a linear (straight line) amortization policy during  the life of your project. Consider the amortization cost for annual future amortization of existing Assets same as the average annual amortization of the last 3 years from your P&L. Add a separate line for the new amortization cost of your new CAPEX using the linear amortization from Year N+1 to the end of your project. 

Page 4 (Projections of P&L): Make a projection of the profit and loss account for 5 years based on the assumptions from the page inputs. Your revenues and costs from the Inputs page should be increased/decreased for rates of revenue/costs growth/falls. Revenues  (Sales) for Year 1 should be taken from the Total Revenues from Year 0 (Year N)  increased/decreased by the rate of growth/decline of your Total Revenues in Year 0. Payout ratio for dividends each year 10%. Income tax 30% Year 1 hereafter corresponds to the year N+1.

Page 5 (Debt): Based on page 2, make a table of amortization of loans and bonds, calculation of interests and coupons, principals using formulas (PMT or other) Use your bonds, loans, and equity to finance your assets and investments. Loan has an interest rate and Bonds have a coupon rate. Both debt sources of funding are used for the duration of the investment.
Page 6 (Cash Flow): 
Calculate net working capital and NWC investments. To do that use the simplified calculation: Receivables and Stocks for Current assets and Liabilities for current liabilities. To obtain the annual receivables, Stocks, and payables you should calculate it every year and determine the annual investments in such items for the purpose of your CF statement here below.

Discount all your Cash Flows with WACC assuming the CF of your last year (Terminal value) is growing in the infinite at a g rate (% growth rate of CF forever) of 2% annually.  
The discount rate (cost of capital) is the weighted average of the cost of capital (WACC) of all your long-term (loan, bonds, and equity) funding sources. You have to calculate WACC on this  Page. Calculate the shareholder's cost using the DDM model (Gordon). For bonds use the yield rate you should calculate or find it from the financial statement of your company if the company has issued the bonds. For Loan use the interest rate you estimate or the lowest interest rate from the financial statement of the existing Loans.

This Accounting Assignment has been solved by our Accounting Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.