Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Bank of the Midwest is a small retail and commercial lender located in a rural, midwest county. The commercial underwriter at the Bank of

The Bank of the Midwest is a small retail and commercial lender located in a rural, midwest county. The commercial underwriter at the Bank of the Midwest is presented with a lending situation.The underwriter has a monthly loan approval maximum of $7 million. As of the last day of the month, $6.3 million of loans have been approved and funded (only $700,000 more is allowed according to the bank's lending policy).

Ride-in-Style, LLC, is a limousine service organized as a partnership by two equal owners, Jim Jones and Rhoda Putnam. They wish to finance two new limousines with a $470,000 purchase price. The partners are able to make a $100,000 down payment to bring the requested loan to $370,000. The following information was requested and submitted with the loan application:

BALANCE SHEET
Cash $ 8,000 Current liabilities $ 5,000
Accounts receivable 1,000 Long-term liabilities 175,000
Limousines 260,000 Partner's Equity 270,000
Office Building 205,000 Retained earnings 24,000
Total assets $ 474,000 Total liabilities and equity $ 474,000

INCOME STATEMENT
Net Sales $ 162,000
Less: Cost of Sales (74,000)
Gross Profit $ 88,000
Less: Operating Expenses (91,000)
Net Loss (Operating Loss) $ (3,000)

STATEMENT OF CASH FLOW
Net Loss $ (3,000)
Add: Depreciation 25,000
Change in Current Assets and Liab (10,000)

Net Cash Provided by Operating Activities $12,000

Net Cash Provided by Investing Activities (8,000)

Net Cash Provided by Financing Activites (3,000)

Net Increase (Decrease) in Cash $ 1,000

The limousines are appraised at $500,000. Net operating income has averaged $40,000 for the last 5 years prior to this year's net loss. The annual debt service is estimated to be $45,000 per year. Gross income for the property is anticipated to be approximately $250,000 annually, and annual operating expenses are verified to be $100,000. The partner's combined personal financial information shows that they earn approximately $20,000 per month, and currently have the following debts - $6,000 in combined mortgages, $1,200 in combined car payments, combined credit card minimum payments of $900, and $600 in other relevant debt. Capital expenditures for operating activities were $2.000 and no dividends.

Calculate and do comments about:

Net Worth Working Capital Loan-to-Value Ratio Debt Service Coverage Ratio Operating Expense Ratio

Debt Yield Ratio Debt Ratio Operating Cash Flow/Net Sales Free Cash Flow (FCF) Comprehensive Free Cash Flow (CFCF)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Lets calculate and comment on the following financial ratios based on the provided information 1 Net Worth Net Worth Partners Equity Retained Earnings ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial and Managerial Accounting the basis for business decisions

Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello

16th edition

0077664078, 978-0077664077, 78111048, 978-0078111044

More Books

Students also viewed these Finance questions