Prepare complete and properly formatted cash flow statement

Reference no: EM131912668

FINANCIAL STATEMENT ANALYSIS FINAL EXAM

1. There are three sections to this exam. With these instructions you will receive an Excel spreadsheet that has three parts in which you must calculate:

a. The cash flow statement for years 9 and 10 (chapter 7)

b. RNOA and ROCE for years 9 and 10 (chapter 8)

c. The operating performance for years 9 and 10 (chapter 1 and 10).

2. Read the instructions carefully and completely before preparing your answers.

3. If an answer requires an excel formula, include your formula in the cell where the answer is calculated. You must show how you calculated the answer.

PART 1 - Prepare a complete and properly formatted cash flow statement for years 9 and 10 using the indirect method. The CFS must be in the proper and complete format. Two point deduction if not in proper format.

Also, keep in mind, if your ending cash balance on the cash flow statement does not equal the cash balance on the balance sheet ... your cash flow statement is incorrect. Don't turn in answers that do not match the balance sheet cash.

PART 2 - Using the financials for years 8, 9 and 10:

A. Calculate the RNOA and ROCE using the basic formula (simple methods) for years 9 and 10. Carry the percentage answers to one decimal place, rounding up if 5 or over.

B. Then, for ROCE disaggregate it into its three major components: RNOA, Leverage and Spread. On the spreadsheet you must calculate and show the answers to 1 through 19 (below) in addition to the RNOA and ROCE calculations. Use averages where required. The NFE calculation includes interest income from investments ... AND ... interest expense from the lease and long term debt. Remember to adjust the net interest by (1-Tax).

C. The Operating Assets (OA), Operating Liabilities (OL), Financial Assets (FA) and the Financial Liabilities (FL) are identified on the Excel spreadsheet in column D next to the corresponding balance sheet account.

1. NOPAT
2. OA
3. OL
4. NOA
5. Avg NOA
6. RNOA using simple method Check number provided
7. NI
8. Avg CE
9. ROCE
10. FL
11. FA
12. NFO
13. Avg NFO
14. NFR
15. NFE
16. Avg NFE
17. Lev
18. Spread
19. Disaggregated ROCE Note: must equal ROCE from #9 above.

PART 3 - Calculate the operating performance financial ratios for years 9 and 10. Use averages where required. Use 365 days for daily averages. Show your calculation formulas in the spreadsheet.

Attachment:- Assignment Files.rar

Reference no: EM131912668

Questions Cloud

Identify the current strategy and bring evidence : Conduct an analysis of internal of the firm by providing details of its current strategic position, the resources and capabilities.

Write about an integumentary system disorder : Write about an Integumentary System Disorder. Make sure sections A --> F are clearly labeled (as shown in my Hemophilia example)

What is a market beta and how is determined : What is a market beta, and how is determined? What is the difference between a project's market beta and the business's or stock's market beta?

Why can mark deduct that interest in the current year : Mark Hancock is a self-employed attorney who operates his law practice as an unincorporated. Why Can Mark deduct that interest in the current year? Explain.

Prepare complete and properly formatted cash flow statement : FINANCIAL STATEMENT ANALYSIS FINAL EXAM - Prepare a complete and properly formatted cash flow statement for years 9 and 10 using the indirect method

What is the company cost of equity : If the stock sells for $43.20 a share, what is the company’s cost of equity?

Respong to a tuning fork of frequency : What is approximately the length of a shortest air column closed at one end that will respong to a tuning fork of frequency 112 Hz? Answer in cm.

Calculate the direct materials quantity variance for july : Calculate the direct materials price variance for July. Calculate the direct materials quantity variance for July. Label variance as favorable or unfavorable.

Company capital structure weights on market value basis : Filer Manufacturing has 8 million shares of common stock outstanding. What are the company’s capital structure weights on a market value basis?

Reviews

len1912668

3/23/2018 6:10:50 AM

Attached is also the example for writer so he can follow example to do exactly similar way. The final exam is due no later than Saturday, March 24, 2018. Read the instructions carefully. If there is any instruction you do not understand or have questions please contact me immediately. Note: The final exam is a reflection of your understanding of the subject. This includes your ability to correctly calculate the answers, and your ability to completely and properly prepare the financial reports as though you were presenting them to your senior management.

Write a Review

Required(*) Message

User Account

All Pages