I need help analyzing comparative balance sheets and a cash flow statement to deny a loan in a business letter. All the details are in the attachments. I need this by Sunday.

Thank you

RC 5-15 MT 480 Case Study Bob Smith Loan Review Data for Teams Comparative Balance Sheets and Cash Flow Statement Worksheet ASSETS Cash and marketable securities Accounts receivable Inventory Other current assets Total current assets Gross Plant and equipment Less: Accumulated depreciation $ $ $ $ $ $ $ 2014 33,411 260,205 423,819 41,251 758,686 1,931,719 (419,044) $ $ $ $ $ $ $ 2013 16,566 318,768 352,740 29,912 717,986 1,609,898 (206,678) Net plant and equipment Goodwill and other assets Total Assets $ $ $ 1,512,675 382,145 2,653,506 $ $ $ 1,403,220 412,565 2,533,771 LIABILITIES AND EQUITY Accounts payable and accruals $ 378,236 $ 332,004 Notes payable Accrued income taxes Total current liabilities $ $ $ $ 14,487 21,125 413,848 $ $ $ $ 7,862 16,815 356,681 Long-term debt Total liabilities Preferred stock Common stock (10,000 shares) Additional paid in capital Retained earnings Less: Treasury stock Total common equity Total Liabilities and Equity $ $ $ $ $ $ $ $ $ 679,981 1,093,829 10,000 975,465 587,546 (13,334) 1,559,677 2,653,506 $ $ $ $ $ $ $ $ $ 793,515 1,150,196 10,000 975,465 398,110 1,383,575 2,533,771 In addition, it was reported that the company had a net income of $3,155,848 and depreciation expenses were equal to $212,366 during 2014. Net Income $3,155,848 Depreciation $212,366 Dividends Paid -$2,966,412 ta for Teams ent Worksheet The bank told Bob to increase cash to $70,000 from 2013 to 2014. But cash increased from $16,566 in 2013 to just $33,411 in 2014, well short of $70,000, ... why... Cash Up or Down $ 16,845 $ 58,563 EXPLAIN $ (71,079) EXPLAIN $ (11,339) $ (40,700) (321,821) 212,366 $ $ (109,455) EXPLAIN 30,420 (119,735) $ 46,232 EXPLAIN $ $ $ 6,625 EXPLAIN 4,310 57,167 $ (113,534) EXPLAIN (56,367) 0 0 189,436 (13,334) 176,102 119,735 depreciation expenses were Explain how the six highlighted accounts impacted cash flow from one year to the next. The accounts either added or reduced the cash balance from one year to the next. I.e., the accounts were either a Source or Use of cash. This one worksheet provides all the data you need to complete the project. You may want to assign each team member a respective 'Explain'. Units 1-3 [MT480: Corporate Finance] Team Assignment Team Assignment: Prepare a Business Letter (due in Unit 3) The ability to interact and solve problems together even at a distance is a key skill in today's business environment. You will demonstrate the ability to solve complex problems by establishing a team setting ensuring all team members properly complete agreed upon and assigned tasks. Your team has a proprietary Team Discussion Board area under Unit 3 labeled Team X Discussion. Your team also has a team-specific email group list, and a private synchronous Chat area, if you choose to use them. Teams sometimes use an instant messaging service, such as AIM. Please post your meeting minutes in your Team Discussion Board area. Setting up a specific time each week to check in may be helpful. This Assignment will assess your knowledge based on the following outcome: PC-1.2: Contribute to team goals and objectives through active participation and collaboration. You will analyze financial data and present the rationale to deny a loan renewal request. Comparative Balance Sheets and a Cash Flow Statement are used in the analysis. After review and analysis of the Cash Flow Statement you will prepare a business letter to explicitly explain to the customer your reasoning for denying the loan. Each team member will be asked to provide their respective analysis of one of the six sections of the team's letter. Teams are required to prepare and post meeting minutes to their Team Discussion Area that will also be submitted with the final Team Assignment. One member of the team will submit the final Team Assignment with the meeting minutes to the Assignment Dropbox. Let's Get Started! Experience has shown the following timeline to be helpful. Please do not feel constrained by this timeline, it is not a graded item. Unit 1, 2, and 3: Wednesday Greet each other in the Team Discussion Area and exchange contact information, time zone, and best meeting days and times. (See Agenda suggestion below) Units 1-3 [MT480: Corporate Finance] Unit 3: Thursday Determine who will lead the project, who will do which part, by when, what your communication expectations are and when you will be meeting next. Unit 3: Friday Confirmation of delegated duties. Delegated parties accept their delegated duty and begin working on their deliverables. Unit 3: Saturday Project Leader reassigns any duties not accepted by individuals on the team and the team member's continue working on their deliverables. Unit 3: Sunday Submit draft Assignment to Project Leader. Project Leader posts draft Assignment in the Team Discussion Board. Unit 3: Monday Team edits/improves the Assignment deliverable. Unit 3: Tuesday One team member submits the Assignment. You may find this to be a helpful guide for an agenda for your first meeting, or initial team discussion posts. AGENDA: Determine Project Leadership. Determine the specifications, resources, and timelines for the project. Determine communication protocol. Determine next meeting. Team Assignment Instructions 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 2013 the bank required Bob to increase the YE 2014 cash balance to at least $70,000. The Cash Flow Statement and Balance Sheet show an actual YE 2014 cash balance of less than $34,000. The Team Assignment requires participation in a team effort to complete the (partially prepared) 2014 Cash Flow Statement. In Seminar 1 you discussed how to complete and use the 2014 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 2015 loan denial. You are aware this action will create dire financial circumstances for Bob's company. As the loan officer you Units 1-3 [MT480: Corporate Finance] 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. The documents for this project will be reviewed in Seminar 1 and the Team Assignment will be due by the end of Unit 3. Requirements This project includes data for the a) comparative Balance Sheets, b) partially completed Cash Flow Statement worksheet and, c) the template outline of the loan denial letter. Each document will be reviewed in the Week 1 Seminar. You will locate the comparative Balance Sheets and Cash Flow Statement worksheet in the Team Assignment Worksheets file. Please use the template outline to prepare the business letter. Criteria for Meeting Minutes Meeting Minutes must include each team members name, date, and notes of the discussions. Minutes to the meetings will be submitted on the same document after your business letter. Directions for submitting your Team Assignment Prepare your Assignment in a minimum of 2 double-spaced pages in length, using size 12 point font in Microsoft Word format. At the end of your paper, add the meeting minutes. Name the file as: MT480 Business Letter Team X. One team member will submit the Team Assignment to the Unit 3 Assignment Dropbox. MT480 Unit 3 Team Assignment: Business Letter Points Possible Content (50%) Response successfully answers the assignment questions based upon the Case Study data; thoroughly uses the text and other literature. Includes a strong thesis statement, introduction, and conclusion. The main points of the paper are developed clearly and explained using the denial letter and appropriate financial and accounting terminology. All arguments are supported well (no errors in logic) based upon the Statement of Cash Flows data. 20 Points Earned Units 1-3 [MT480: Corporate Finance] Achievement of a well-synthesized paper using contributions from team participants to achieve a paper that resembles the collective talents of the group. The team presents minutes to the meetings based upon project specifications. 20 Analysis and Critical Thinking (30%) Response exhibits strong higher-order critical thinking and includes appropriate judgments, conclusions and assessments are based on the analysis of the Balance Sheet and Statement of Cash Flows. 10 Analysis includes proper classifications, explanations, comparisons and inferences based on the cash flow representations. Team's work includes recognition of accounts. Team's work is reconciled back to the financial data provided. 10 Writing (20%) Sentences are clear, concise, and direct; tone is appropriate. Project is free of serious errors; grammar, punctuation, and spelling help to clarify the meaning by following accepted conventions. 5 The paper includes the provided format of the Bank Denial Letter. 5 Total 70 Program Outcome: Work in teams to achieve collective goals. Not Assessed N/A No work was received by the instructor. No Progress Team member shows little, if any, understanding or progress toward achievement of this outcome. 0 Introductory Team member marginally attempts to contribute team goals and objectives, but lacks understanding of team goals and objectives. 1 Units 1-3 [MT480: Corporate Finance] Emergent 2 Team member supports team goals and objectives through fulfilling some (e.g. less than 50%) of his or her own contributions. Practiced 3 Team member supports team goals and objectives through fulfilling most (e.g. more than 50%) of his or her own contributions. Proficient 4 Team member supports team goals and objectives through completely fulfilling his or her own contributions as well as occasionally assisting and/or supporting others in their contributions. Mastery 5 Team member fully supports team goals and objectives through fulfilling his or her own contributions as well as consistently assisting and/or supporting others in their contributions. Unit 3 [MT480: Corporate Finance] Team Assignment Outline Business Letter: Bank Loan Review Dear Mr. Smith, Last week your loan request was presented to the bank's loan committee. The outcome of the committee's vote resulted in a non-renewal of the loan. The loan committee focused on the following issues...Students completes the following... 1.... summarize...focus on \"the\" one account that significantly \"reduced\" cash balances. Explain to Bob how this one account could be the main reason the required $70,000 cash balance was not maintained. 2...explain...note two other accounts that dramatically reduced cash flow/growth and are of particular concern to you. Express an idea that might immediately improve this matter. 3...recognize...a couple of accounts that did increase cash flow. Make a specific note to Bob regarding how and why these accounts lead to inflows of cash; 4...explain...to Bob three actions that would continually increase cash flow and \"correct the situation.\" Explain that you look forward to meeting again in the 6 months in hopes of a loan approval. Regards, Bank Loan Review Team (List all participating team members)