Analyze financial data and present the rationale to deny

Assignment Help Financial Management
Reference no: EM13856758

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 complexproblems 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 XDiscussion. Your team  lso has a team-specific email group list, and a privatesynchronous Chat area, if you choose to use them. Teams sometimes use an  nstant messaging service, such as AIM. Please post your meeting minutes in your TeamDiscussion Board area. Setting up a specific time  ach 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 businessletter to explicitly explain to the customer  your reasoning for denying the loan.

? Each team member will be asked to provide their respective analysis of oneof 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.

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   team effort to complete the (partially prepared) 2014 Cash Flow Statement. In Seminar 1 you discussed how to completeand use  he 2014 Cash Flow Statement outcomes to explain how specific accountsinfluenced Bob's low cash balances...in other words...some  easons 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  ill 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  alance  heets and Cash Flow Statement worksheet in the Team Assignment Worksheets file. Please use the template outline to prepare the business letter.


Attachment:- mt480_u3_team_worksheets.xlsx

Reference no: EM13856758

Questions Cloud

Proof or verification using mathematical reasoning : Prove that the Cayley digraph given in does not have a Hamiltonian circuit. Does it have a Hamiltonian path - problem using a valid method of proof or verification using mathematical reasoning.
What are the various kinds of budgets? : What are the various kinds of budgets? Please explain each
Constitute the real basis of material production : Marx’s metaphor for the “social relations” and the productive forces that constitute the “real basis” of material production
Major means of production are privately owned : Which of the following is an economic system where the major means of production are privately owned?
Analyze financial data and present the rationale to deny : Analyze financial data and present the rationale to deny a loan renewal request
Qualifying or determining dimensions : Glen is a 45-year-old financial executive who owns his own business and frequently entertains clients at dinner or with sports or other outdoor events on weekends. He is married and has three young children. Glen is looking for an investment that wil..
Calculate the amounts and compositions of the exit streams : Fresh halibut livers containing 25.7 wt % oil are to be extracted with pure ethyl ether to remove 95% of the oil in a countercurrent multistage leaching process. Calculate the amounts and compositions of the exit streams and the total number of the..
Identifying promising target markets can be difficult task : Segmentation for the purpose of identifying the most promising target markets can be a difficult task. Many successful companies are able to develop or modify their products to address a number of market segments, according to the needs of customers ..
Describe the stepping stone method : The stepping stone method is being used to solve a transportation problem. There is only one empty cell having a negative improvement index and this index is -2. The stepping stone path for this cell indicates that the smallest quantity for the ce..

Reviews

Write a Review

Financial Management Questions & Answers

  What is the geometric average return

RedStone Mines stock returned 7.5, 15.3, -9.2, and 11.5 percent over the past four years, respectively. What is the geometric average return?

  What is this stocks expected total rate of return

You buy a share of The Ludwig Corporation stock for $19.40. You expect it to pay dividends of $1.07, $1.16, and $1.2576 in Years 1, 2, and 3, respectively, and you expect to sell it at a price of $28.27 at the end of 3 years. Calculate the growth rat..

  Explain how using a risk-adjusted discount rate improves

Explain how using a risk-adjusted discount rate improves capital budgeting decision making compared to using a single discount rate for all projects?

  Discounted cash flow calculation to determine the npv

A 4-year financial project is forecast to have net cash inflows of $20,000; $25,000; $30,000; and $50,000 in the next 4 years. it will cost $75,000 to implement the project, payable at the beginning of the project. If the required rate of return is 0..

  The estrada company uses cost-plus pricing

The Estrada Company uses cost-plus pricing with a 0.32 markup. The company is currently selling 100,000 units. Each unit has a variable cost of $3.80. In addition, the company incurs $184,400 in fixed costs annually. If demand falls to $76,000 units ..

  Calculate the macaulay duration-macaulay convexity

Calculate the Macaulay duration, Macaulay convexity, and dispersion of a 10-year bond with semiannual coupons paid at 6% per year earning an annual effective yield of 11%.

  Arithmetic and geometric returns for the stock

A stock has had returns of 11 percent, 29 percent, 16 percent, −17 percent, 29 percent, and −7 percent over the last six years. What are the arithmetic and geometric returns for the stock?

  What is the retained earnings balance at the end of the year

Cindy's Crafts had beginning retained earnings of $51,200. During the year, the company reported sales of $112,400, costs of $75,800, depreciation of $9,100, dividends of $1,500, and interest paid of $2,300. The tax rate is 34 percent. What is the re..

  Memos with records revealed reconciling items

The cash account for Online Medical Co. at June 30, 2014, indicated a balance of $9,925. The bank statement indicated a balance of $11,540 on June 30, 2014. Comparing the bank statement and the accompanying canceled checks and memos with the records ..

  How is relevant costing used in decision making

How is relevant costing used in decision making? What would the relevant costs be in deciding whether to discontinue a segment of business? What would the relevant costs be in deciding how to optimize use of a constrained resource?

  Earnings per share on the common stock was

RileyCorp. has earnings after taxes of $210,000. Interest expense for the year was $40,000; preferred dividends paid were $45,000; and common dividends paid were $30,000. Taxes were $22,700. The firm has 100,000 shares of common stock outstanding. Ea..

  Environmental consulting for businesses with smokestacks

Dicen and two others formed a company, Sesco, to do environmental consulting for businesses with smokestacks. Two years later, the company was bought by New Sesco, Inc. Dicen signed an agreement that he would not do business in competition with New S..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd