Analyze the case study frank smith plumbing

Assignment Help Corporate Finance
Reference no: EM131152109

Cash Flow Analysis 4 pages.

IF YOU CAN" DELIVER ON TIME DON'T CONTACT ME

Analyze the case study, "Frank Smith Plumbing."
Analyze the "Frank Smith Plumbing's Financial Statement" spreadsheet.
Compare the cost of the truck to the cash flow records
Compile your calculations in a Microsoft Excel document
Develop a 1,050-word analysis and include the following:

• Explain why limited leverage is good for business.Show the profitability of the project so that Stephanie can convince her father to purchase the truck by borrowing money.

• Explain how Stephanie should convince her mother that it is inappropriate to call the bank manager and his wife for assistance in getting the loan approval?

• Analyze whether the investment in the truck is profitable.

• Explain whether it is more beneficial for Frank to close his business.

• Explain what you would do in this same situation.

Format your assignment consistent with APA guidelines.

Frank Smith Plumbing

Mohammed R. Ahmed, DBA and Betty E. Ahmed, DBA

Read the following case study to complete the Week 4 assignment.

Frank Smith has been a plumber in the college town of Turlock, CA for the last thirty years. All the people who know him call him Frankie because he is friendly, social, and charges a fair price for his services. His business has grown because new customers become repeat customers. He has worked hard to support his family and has raised three children who have attended the local school system. However, in recent years, he has had to work overtime to ensure he has the funds to financially support his daughter in the business program at the local state university. He encourages all his children to pursue a college education because he knows it will be valuable in their futures and, as a rule, Frank has never believed in borrowing money. Every time he has purchased something - such as tools, vehicles, equipment, or even his children's college educations - he has paid in cash.

Frank has been using his plumbing truck for the last 14 years. However, recently it has begun stalling and the mechanic has recommended buying a new fuel-efficient truck rather than repairing his old, gas-guzzling one. Unfortunately, Frank has used all of his money to pay for his living expenses and daughter's college education. He has explored purchasing a new truck and does not have enough cash saved to buy one outright.

Recently, the Smith family got together for dinner, and Frank started explaining that it was time to forego self-employment in favor of working for a plumbing company because he could not afford to buy a new truck. The family reacted in sorrow, lamenting that Frank would be forced to work for a company when he had been running a successful business on his own for so long.

The eldest daughter, Stephanie, a senior studying business administration, listened to her father and after a pause, said, "You do not have to give up your business. You can borrow money from the bank, pay monthly installments on the truck, and still have the independence of owning your own business."

Frank's wife, Elena, joined the conversation and reminded Frank that he has been servicing Hosea Garcia, the manager of the community bank, for the last two decades. Elena told Stephanie to contact Garcia because she was sure he would help Frank get the loan. Stephanie responded that it would not be proper to contact Hosea privately and ask for assistance because, as the manager of the bank, Garcia has to follow strict rules when evaluating the creditworthiness of the borrower before the bank can lend.

Stephanie further explained the importance of ethics in the financial service industry: she reminded her mother that banks, in particular, are very strict when lending money, especially after the 2008 financial crisis. Based on what she learned in her ethics class, Stephanie explained that it was not appropriate to contact the bank manager. Instead, she advised the best approach would be to go through all the financials, prepare cash flow statements for Frank's business, fill out a loan application, provide all the required bank documents and let the bank decide on the loan. Based on the financial information, Stephanie felt that her dad would be approved for the loan.

However, Elena said, "I am not going to take that chance of your dad having to go to work for somebody else. I am going to call Hosea and his wife tomorrow and tell him to help get the loan. You do whatever you need to do, and I will do what I need to do."

This put Stephanie in a difficult position. On one hand, she was aware of the ethical issues involved and on the other hand, she did not want her father to have to give up his business. Unsure of how to handle the situation, Stephanie decided to research and get advice on the ethical issues at school the next day.

In the meantime, Stephanie explained to her father, "Based on what I have learned in business school, entrepreneurship is the key to success, and limited leverage is always good for business. You have been working for over 20 years and based on your income, you should not have any problem borrowing from the bank."

Frank asked his daughter, "Stephanie, how can I make profits and pay this much money for the truck?"

Stephanie replied, "I am going to take all the information, check with the bank, and do a financial analysis to determine whether the investment in the truck is profitable or not. You have paid for my education, and I am going to pay you back by applying my knowledge to help you make a good business decision."

Stephanie gathered the information found in the attached spreadsheet. The information includes the cost of the truck, cost of additional equipment on the truck, cost of capital, tax rate, and the life of the truck. It also includes cash inflows generated from the use of the truck.

Complete the following tasks:

1. Assume you are Stephanie, research whether there is an ethical problem with Elena calling the bank manager and his wife and getting the loan approved. If there is an ethical issue, how should Stephanie convince her mother that it is inappropriate to call the bank manager and his wife for assistance in getting loan approval?

2. Explain why limited leverage is good for business.

3. Based on the given information, tax rate, and depreciation show the profitability of the project so that Stephanie can convince her father to purchase the truck by borrowing money.

Attachment:- Frank_Smith_Plumbing_Spreadsheet.xls

Reference no: EM131152109

Questions Cloud

What are the patterns and characteristics you would look : What are the patterns and characteristics you would look for while screening a potential abused or neglected child? How would these patterns and characteristics help you determine the proper assessment methods? Which methods would you use in this s..
Problem regarding the securities and exchange commission : As you see in the media, many companies get in big trouble with the Securities and Exchange (SEC) Commission which often leads to bankruptcy. Conduct research and locate one company that had violations with the SEC and ultimately lead to a petitio..
Analyze the evolution of the countrys monetary system : Analyze the evolution of the country's monetary system, including the impact of any fiscal monetary and trade policies. Describe the major components of the monetary system, including organizations and financial institutions.
Discuss the common elements of a county-wide ehr : Discuss the common elements of a county-wide EHR and what type of organization it is, the mix and demographics of the clients, types of services provided, local resources, and other information to help thoroughly understand the data needs of the o..
Analyze the case study frank smith plumbing : Analyze whether the investment in the truck is profitable. Compare the cost of the truck to the cash flow records. Explain whether it is more beneficial for Frank to close his business. Explain what you would do in this same situation.
The american red cross engaged in a fundraising campaign : How did fundraising for 9/11 differ from its traditional practices? - What are some main concerns the Red Cross should have been aware of when it began fundraising for its Liberty Fund?
Explain the brand and the brand image : Choose a brand from this list (it must be different from one already chosen and discussed on the board. First come, first choice). Explain the brand (name, logo, other identifiers) and the brand image
Probability that the mean fare is between $20 and $23 : What is the probability that the mean fare is between $20 and $23? Please type the solution and the answer. Use the formula editor to enter numeric values and formulas.
The axial compression of the deck in a cable stayed bridge : Because of the axial compression of the deck in a cable stayed bridge, buckling is a concern. In this simple bridge, each pylon carries one frontstay and one backstay as shown.

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Here are book- and market-value balance sheets of the

here are book- and market-value balance sheets of the united frypan company

  We have a 400000 30 year 12 mortgage we want to knowathe

we have a 400000 30 year 12 mortgage. we want to knowa.the monthly mortgage payment.b.how much we need to pay the bank

  Weighted-average method

Evaluation of Equivalent units using weighted average method and evaluate the number of equivalent units for materials using the weighted-average method.

  What is required return using fama-french three-factor model

If the expected value of the size factor is 5% and the expected value of the book-to-market factor is 4%, what is the required return using the Fama-French three-factor model?

  Geocentric approaches to staffing

Explain the polycentric, ethnocentric, and geocentric approaches to staffing.

  Suppose you are an analyst asked to prepare a valuation of

suppose you are an analyst asked to prepare a valuation of yeats valves and controls yvc for kate porter. she has asked

  Describe and evaluate the companys business strategy do you

describe and evaluate the companys business strategy. do you think it is viable?why did the attempt to purchasethe

  Calculate current ratio and operating profit margin ratios

Calculate the following ratios assuming RareMetals Inc. uses the FIFO method of inventory valuation: gross profit margin, operating profit margin, net profit margin, current ratio, and quick ratio.

  Xyz plc is a small organisation that specialises in

xyz plc is a small organisation that specialises in providing on-site cleaning services to both commercial and

  What is the project equivalent annual cost

If the required return is 8 percent, what is the project's equivalent annual cost, or EAC? (Do not round your intermediate calculations.)

  Theory question based on common stock dividend yield and

theory question based on common stock dividend yield and capital gain.if you bought a share of common stock you would

  How much external equity must gardial seek now

How much external equity must Gardial seek now to expand as planned? In millions ex: 1.2. Round to two decimal places.

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