Financial Statement Analysis

There are two parts to this Assessment. Please only complete Part 1! Only providing instructions for Part 2 for reference.

Assessment Part 1:

This Competency Assessment assesses the following outcome(s):

GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English.

In this first part of the Assessment, you will prepare a business letter to share your advice with a client. You will explain complex financial data and discuss the cause and effect of select accounting transactions on cash balances.

Read the fictional scenario and respond to the checklist items.

Scenario:

The Chief Financial Officer (CFO), Patricia Bendiger of Tellabine Company in Denver, Colorado is asking for your advice. The CFO explains sales are increasing but there is a constant matter of not having enough cash to meet payroll or pay vendors within 30 days.

Checklist: Prepare a business letter to the CFO:

1. Explain why cash can go down even when sales are up; refer to “receivables.”

2. Analyze the scenario and explain three accounts the CFO should review each day and explain why. Focus on short-term balance sheet accounts, i.e., “receivables and payables.”

3. Your business letter should:

Use the accepted business letter format and example as provided above.
Utilize Standard English and use correct spelling and grammar.
Provide a clearly established and sustained viewpoint and purpose.
The writing should be well ordered, logical and unified, as well as original and insightful.

4. Your business letter must be written in a minimum of 2 pages using APA 6th edition formatting. Please label your Assessment as “MT480M1-1_CFO_your name” and submit to the M1 Assessment Dropbox.

Minimum Submission Requirements

Address all the checklist items.
Include a strong thesis statement, introduction, and conclusion.
Support all arguments (no errors in logic).
APA formatting dictates that you use Times New Roman 12-point font, with correct citations, uses Standard English with no spelling or punctuation errors.
If work submitted for this competency assessment does not meet the minimum submission requirements, it will be returned without being scored.

Assessment Part 2:

This Competency Assessment assesses the following outcome(s):

MT480M1: Analyze financial statements to measure the financial performance of a business entity.

PC-1.2: Contribute to team goals and objectives through active participation and collaboration.

The ability to interact and solve problems together — even at a distance — is a key skill in today’s business environment. In this part of the assessment you have the opportunity to analyze financial data and present the rationale to deny a loan renewal request besides getting some practice operating as you were a member of a team.

Instructions: Read the scenario in the pdf provided below and then access the data spreadsheet and the denial letter template, as well as the grading rubric. Then, as if you were a member of a team, respond to the checklist items below.

Checklist:

In a Microsoft® Word® document address the following as if you were a member of a team (although you alone are responsible for the deliverables) based on the scenario in the pdf provided:
-Provide the goals, resources, and timelines for the team project.

-Explain the communication protocol for team members.

-Explain how you resolved the problems on page #8 of the pdf.

Access the denial letter template below and complete the loan denial letter.
As the loan officer, you must pass along the news in a business letter that is most professional and written in an objective manner. Please use values in the letter whenever possible.

Access the data worksheet below and complete it.
Using analysis of the data sheet, explain in your letter why you are denying the loan renewal based on:
-Accounts Receivable

-Accounts Payable

-Inventory

Submit the three completed documents: (1) the Microsoft® Word® document explaining your team process, communication, and problem solving from bullet #1 (label as part a); (2) include the loan renewal denial letter (label as part 2b) and (3) the data worksheet (label as part 2c) to the Dropbox labelled as Assessment “MT480M1-2_CFO_your name” and submit to the M1-2 Dropbox.
Access the loan renewal denial letter template

Access the data worksheet

Access the assessment rubric

Minimum Submission Requirements

Address all the checklist items.
Include a strong thesis statement, introduction, and conclusion. The main points of the response should be developed and explained clearly in the denial letter with appropriate financial and accounting terminology.
Support all arguments (no errors in logic) based upon the Statement of Cash Flows data.
Exhibit strong higher-order critical thinking and include appropriate judgments, conclusions, and assessments based on the team’s analysis of the Balance Sheet and Statement of Cash Flows.
Provide proper classifications, explanations, comparisons, and inferences based on the cash flow representations. Submission includes recognition of accounts and team’s work is reconciled back to the financial data provided.
Your content should follow proper APA citation style. For assistance with APA formatting, go to the Writing Resources accessed through the Academic Success Center within the Academic Tools area of the course. APA formatting dictates that your paper includes a cover sheet, the paper is double spaced, in Times New Roman 12-point font, with correct citations, and uses Standard English with no spelling or punctuation errors.
If work submitted for this competency assessment does not meet the minimum submission requirements, it will be returned without being scored.