Reference no: EM131692568
Group Project
Introduction and Objectives
The objectives of the project assignment are for students to:
- Demonstrate their understanding of, and ability to applyconcepts covered and learned in the course to a human resources business context.
- Improve written business communication skills.
Required
You and your colleagues have just purchased the Leap Forward Placement Agency (LFPA). You own 100% of the shares of LFPA. To provide your company with some financial flexibility you are approaching a bank for a bank loan of $500,000. Accordingly you need to prepare a financial information package for the bank that includes:
1. A balance sheet, income statement and statement of retained earnings for LFPA for 2015 and 2016. When you purchased LFPA, you were provided with the financial data but it is disorganized and has not been put into financial statement format.
2. A financial statement analysis of the 2015 and 2016 data complete with a horizontal analysis, a vertical analysis and the appropriate financial statement ratios. Some ratios from the placement and recruiting industry have been supplied.
3. A cash budget and projected income statement for 2017 for LFPA. To assist with this you may wish to prepare additional supporting schedules like a sales budget, a cash receipts budget, a direct wages budget and a cash disbursements budget
4. A cost volume profit analysis for 2017 that identifies
a. which expenses are fixed and which expenses are variable - note some expenses are mixed and therefore need to be split into their variable and fixed components,
b. the breakeven point in number of placements and dollars
c. the number of placements that are required to be sold to generate an after tax profit of $200,000, of $400,000 and of $600,000. Assume a tax rate of 25%.
d. If sales in 2018are projected to increase by 10% from 2017 what will the percentage increase in incomebefore taxes from 2017 to 2018be?
5. A qualitative report that includes:
a. An executive summary of your financial package for the bank manager withan overview of the information/analysis that you supplied, key highlights from your analysis and a conclusion on why the bank should grant you the loan. Make sure you are presenting the information with your objective in mind (you want the bank to give you a loan).
b. A qualitative interpretation of each type of analysis done - what does the analysis tell you and how does it help or hinder LFPA from being a good applicant for the loan.
6. A presentation to the bank manager (your classmates will act as the bank manager and listen to and evaluate your presentation.
Summary of Information Provided
Each group has been given an excel spreadsheet that includes:
a) A tab with project data - financial statement data, additional data for ratio calculations, CVP analysis and budget preparation. Note that each groups' financial data is slightly different.
b) Tabsfor each of the financial statements you need to create
c) A tab for you to do your ratio calculations in
d) A tab for you to do your CVP analysis in
e) A tab for your cash budget (with some examples of headings/descriptions)
You may insert additional tabs if you wish to do so.
|
Discuss the appropriateness of the research design for study
: Discuss appropriateness of research design for study, reliability, validity, sampling methods, and any potential bias. Identify any ethical or diversity issues.
|
|
What is the probability that the proposition will pass
: The number of votes cast in favor of a controversial proposition is believed to be approximately normally distributed with mean 8,000 and standard deviation.
|
|
How technology changed the marketing landscape
: Identify and Describe how technology changed the marketing landscape?
|
|
Determine the normal distribution of small daily fluctuation
: Under the system of floating exchange rates, the rate of foreign money to the U.S. dollar is affected by many random factors, and this leads to the assumption.
|
|
What does the analysis tell you
: Demonstrate their understanding of, and ability to applyconcepts covered and learned in the course to a human resources business context
|
|
View of personal and corporate spiritual formation
: How does this align with your view of personal and corporate spiritual formation?
|
|
Probability that a randomly chosen wine will score high
: In the May 15, 2007, issue of the magazine, the burgudy Domaine des Perdrix received a rating of 89.2. What is the probability that a randomly chosen wine.
|
|
Compute what weight range must specified for each category
: The weights of domestic, adult cats are normally distributed with a mean of 10.42 pounds and a standard deviation of 0.87 pounds.
|
|
Why would these ratios be useful in strategic planning
: Long-term creditors and stockholders are interested in a company's long-run solvency, particularly its ability to pay interest as it comes due and to repay
|