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

  Intends to make its first dividend payment

Hayden Ltd intends to make its first dividend payment 5 years(s) from now. It then intends to pay dividends annually thereafter. The company has announced it expects the first three dividends to all be of the magnitude of around 5 cents per share.

  Defines the terms of sale

Which one of the following defines the terms of sale?

  Calculate the liquidity ratios and leverage ratios

Using Income Statement and Balance Sheet figures for 2007, calculate the liquidity ratios and leverage ratios for the company. Show your work.

  Like ordinary stocks-exchange traded funds

Treasury bond yields are commonly used as the basis for yield curves because they are low risk and homogeneous in nature. The mutual fund, and not the investor, is responsible for all income taxes on capital gains and dividends earned by the fund. Li..

  How would you calculate their net worth

Fatimah and Ahmad, both 30 years old, own a house worth $120,000 and have a yearly income of $50,000, monetary assets of $15,000, two cars worth $30,000, and furniture worth $10,000. The house has a $100,000 mortgage, they have college loans of $15,0..

  Firm sell to break-even on a cash basis

The Motor Works is considering an expansion project with estimated annual fixed costs of $71,000, depreciation of $38,500, variable costs per unit of $17.90 and an estimated sales price of $26.50 per unit. How many units must the firm sell to break-e..

  Show the preset value of the present collection experience

Using NPV calculation, show the preset value of the present collection experience and calculate the NPV of the proposed 2/10, net-30 terms.

  Bill plans to fund his individual retirement account

Bill plans to fund his individual retirement account (IRA) with the maximum contribution of $2,000 at the end of each year for the next 20 years. If Bill can earn 12 percent on his contributions, how much will he have at the end of the twentieth year..

  What is the internal rate of return on this new plant

Microwave Oven Programming, Inc is considering the construction of a new plant. The plant will have an initial cash outlay of $7 million (= -$7 million), and will produce cash flows of $2.9 million at the end of year 1, $5 million at the end of year ..

  The break-even point

The break-even point is the

  Explain organisations benchmarking efforts

Explain this organisations benchmarking efforts (or lack thereof). If benchmarking is employed, identify how the currently used benchmarks align with or address international standards.

  What is the average real risk premium

You’ve observed the following returns on Doyscher Corporation’s stock over the past five years: –24.6 percent, 13.4 percent, 29.8 percent, 2.2 percent, and 21.2 percent. The average inflation rate over this period was 3.22 percent and the average T-b..

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