CF Post ass2

SUMMARY

In this unit, you learned how daily business transactions are transformed into standard financial reports. You learned to evaluate those financial statements to analyze the company’s past performance, the current financial status, and cash flows associated with capital investment decisions. You also learned that managing cash flows and financial statement analysis is a core activity for finance managers and a foundation for business success. In addition, you studied standard financial reports and five classifications of ratios. As you learned to calculate financial ratios, you moved one step closer to understanding the essentials of analysis.

Preview the Team Assignment

Be sure to review the team timeline to ensure your team completes this assignment on time: 

team timeline and meeting minutes requirements

.

This team assignment is being introduced to you in Unit 1, so you can begin collaborating and working as a team early. It is associated with the following Course Outcome, but the assignment is due in Unit 4:

MT480-1: Analyze financial statements to measure the financial performance of a business entity.

In this course, you have an opportunity to work with your classmates in teams. Interacting and solving problems together, even at a distance, is a key skill in today’s global organizations.

In this assignment, you will be assessed based on the following Course Outcome:

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

You will demonstrate the ability to solve complex problems by establishing a team setting and ensuring all team members complete the agreed-upon and assigned tasks properly. Each team member is required to fully support the team goals and objectives by fulfilling their contributions and consistently assisting and/or supporting others in their contributions.

The team assignment will be due in Unit 4. You should begin communicating with your team throughout the first three units. Your team will be assigned by your instructor.

Your team has a proprietary Team Discussion Board area under Unit 10 labeled Team X Discussion. Scroll down, and when you see “Filter by:” then select “All groups.” Then you will see the option to choose Group 1, 2, 3, etc.

Your team also has a team-specific email group list and a private synchronous discussion area. Please post your meeting minutes in your Team Discussion Board area. Setting up a specific time each week to check in may be helpful.

Requirements:

This assignment represents the primary steps of understanding the nature of cash flows in a business. You will use y ear-to-year comparative balance sheets in the analysis. After review ing and analyzing the data, you will prepare a business memo to outline the sources or uses of specific account cash flows and how these outcomes support your reasoning for approving or denying the loan. The analysis is based upon year-to-year changes in these specific balance sheet sections: Accounts Receivable, Inventory, Accounts Payable, Wages Payable, Plant Property and Equipment, and Long-Term Debt.

You will:

· Analyze financial data , present the rationale for what your loan committee (team) wants to do on the loan renewal request, and submit supporting documents.

· Participate in the Team Discussion Board located under Unit 10 in the left navigation of your course.

· Each team member is required to individually submit the Team Peer Evaluation Form to the Unit 4 Team Peer Evaluation Form Dropbox. The form is located under Course Documents.

Instructions: Read the scenario, and then access the data worksheet below. Review the grading rubric, which provides tips on organizing your team process.

Scenario: The team assignment requires an analysis of specific financial data of Bob Smith, Inc. Bob is an existing bank customer. When the loan to Bob was originally made in 2016, the bank required Bob to increase the YE 2016 cash balance to at least $70,000 to qualify for the interest rate that the bank used for the original loan. This cash balance was required for the bank to make its target yield on the loan created. The Cash Flow Statement and Balance Sheet show an actual YE 2017 cash balance of less than $34,000.

The team assignment requires participation in a team effort to complete the 2017 Cash Flow Statement. In addition, your team will also prepare “Common Sized Financial Statements” for the 2 years shown. In the Unit 1 Seminar, you discussed how to complete and use the 2017 Cash Flow Statement outcomes to explain how specific accounts influenced Bob’s low cash balances; in other words, some reasons why Bob has no cash!

This information allows you to substantiate the 2018 loan denial or renewal request. Your team is the bank’s loan committee, and you will address an internal memo to the loan officer in charge of this loan facility, giving the committee’s decision on whether to approve the loan as is, renew the loan with modifications, or deny the loan request. Be sure you move away from definitions to analysis. You do not need to give definitions of balance sheet accounts.

The Balance Sheets and Cash Flow Statements provided in the data worksheet below will assist you in your analysis. From these documents, and from the ones you produced, discuss the following:

· The operating cycle of the company

· The covenants within the CC&Rs that the company did not comply with

· The Common Sized Financial Statement (CC&R s)

· The Cash Flow Statement

· What did management do to fall short of the minimum cash requirements?

· Was the company’s failure to meet cash balance requirements a result of the company being unable to meet the requirement or because of management actions?

· What could be management’s motivation for not complying with the loan’s CC&Rs?

· Where was the major portion of the company’s working capital used?

· What could management have done to comply with the CC&Rs they agreed to?

· Finally, what does your loan committee want to do about the renewal of this loan? In this area, you can:

A. Renew the loan without changing the loan conditions.

B. Renew the loan and modify the conditions to what is now required by the bank to receive loan approval.

C. Decline the loan.

Remember that banks approve or deny loans based on the 5 Cs of credit, which are:

· Character

· Capacity

· Capital

· Collateral

· Conditions

Your loan committee should discuss these when deliberating what to do with this loan and include an overview of this discussion in the memo to the company’s loan officer.

In your memo:

· Include a strong thesis statement, introduction, and conclusion. The main points of the response should be developed and explained clearly in the memo 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. Your submission should include recognition of accounts, and the team’s work should be reconciled back to the financial data provided.

Please only answer the items highlighted red.

MT80 Unit 4 Assignment 2

CC&Rs for Bob Smith, Inc.

During the original loan, the bank included, as part of the loan documentation, a
document called Covenants, Conditions & Restrictions (CC&Rs), which the company
had to comply with to maintain its credit facility with the bank. The major conditions of

this included:

1. The company will maintain at least $70,000 in their DDA (noninterest bearing

checking) at all times as compensating balances against their loan.

2. The company will maintain a current ratio of at least 2:1.

3. The company will maintain a quick ratio of at least 1.5:1.

4. The company will not increase officer salaries by more than 5% while the loan is
outstanding.

5. The company will not pay bonuses to officers without the bank’s explicit approval.

Teams will consider compliance with the loan’s CC&Rs as part of their loan approval

process.

2017 and 2016 Comparative

ASSETS 2017 2016

Cash $ 33,411$ $ 16,566$

Items 1 to 6. Note the $ value

effect on Cash. Did the change in

balances from one year to the

next create (+) or ‘use’ (-) cash?

Note the accounting or finance

issue related to each of the six

accounts reviewed.

Accounts Receivable $ 260,205 $ 318,768

Inventory $ 423,819 $ 352,740 71,079

Other current assets $ 41,251 $ 29,912 (11,339)$

Total Current Assets $ 758,686 $ 717,986 (40,700)$

Plant Property and Equipment $ 1,512,675 $ 1,403,220 109,455

Goodwill and other assets $ 382,145 $ 412,565 30,420$

Total Assets $ 2,653,506 $ 2,533,771 (119,735)

LIABILITIES AND EQUITY

Accounts Payable $ 378,236 $ 332,004 46,232

Wages Payable $ 14,487 $ 7,862 6,625

Accrued income taxes $ 21,125 $ 16,815 4,310$

Total Current Liabilities $ 413,848$ $ 356,681$ 57,167$

Long-Term Debt: Bank Notes $ 679,981 $ 793,515 (113,534)

Total Liabilities $ 1,093,829 $ 1,150,196 (56,367)

Total Common Equity $ 1,559,677 $ 1,383,575 176,102

Total Liabilities and Equity $ 2,653,506 $ 2,533,771 119,735

XYZ Bank told Bob to increase cash to $70,000 from 2016 to 2017. But cash increased from $16,566 in 2016 to just $33,411 in 2017, well short of
$70,000. In this assignment, you will review six select changes in the Balance Sheet accounts, highlighted in yellow, to bett er understand how these
individual account changes impact overall cash flows.

Needed to foot the Cash Flow Statement all the way
back to 2017 cash position.
Net Income $3,155,848
Depreciation 212,366
Dividends Paid 2,966,412
Tax 225,700