MT480 Loan Committee Memo-Unit 4 group project
docx
keyboard_arrow_up
School
Purdue Global University *
*We aren’t endorsed by this school
Course
480
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
7
Uploaded by AgentLightningAnteater25
1
Loan Committee Memo Group 6
MT480 – Corporate Finance
Professor Sandy McDonald
December 5, 2023
2
Date: December 5, 2023
To: Charles Riddick, Loan Officer
From:
Loan Committee Lead
Subject:
Loan decision for Bob Smith, Inc.
In the course of the original loan, as part of the loan documentation, the bank requirements
include, Covenants, Conditions & Restrictions (CC&Rs), for Bob Smith, Inc., to maintain its
credit facility with the bank. To remain in compliance, the following conditions need to be met:
●
Maintain at least $70,000 in checking at all times
●
Maintain a current ratio of at least 2:1
●
Maintain a quick ratio of at least 1:5
●
Do not increase officer salaries by more than 5% while the loan is outstanding
●
Do not pay bonuses to officers without the bank’s explicit approval
To evaluate Bob Smith Inc.’s loan request, a financial analysis was performed using the CS
Balance Sheet and Statement of Cash Flows. The bank previously required Bob Smith, Inc. to
increase its year-end 2016 cash balance to a minimum of $70,000 to qualify for the same interest
rate on the original loan. However, the company’s balance did not meet the requirement, nor did
it meet any of the conditions listed above.
Management did not Comply with the CC&Rs
The CC&Rs requirement that the company did not comply with, displays a cash balance of less
than $34,000.
The debt-to-equity raises concerns about the company’s financial health and
failure to meet financial obligations. Cash flow management is the key to long-term business
sustainability. More than just tracking expenses and income, this practice helps businesses plan
for future investments and create strategies that facilitate success (Partnership Invoice Finance,
2023). Analysis was performed of the Accounts Receivable, Inventory, Accounts Payable, Wages
Payable, Plant Property and Equipment, and Long-Term Debt.
Current Ratio and Quick Ratio for CC&R Compliance
The current ratio shows a company's liquidity and whether it can financially manage short-term
loan obligations based on its asset-to-liability ratios. The quick snapshot of the company’s
financials with their current ratio of 1.83; we can determine their liquidity is average. The
company’s current assets stand at $758,686.00 which is less than the ideal 2:1 ratio of their
liabilities, which are $413,848.00, showing they may not have issues paying back short-term
loans, but would still be a higher risk. The company’s quick ratio of 0.81 shows that without their
3
inventory asset of $423,819.00 which is 15% of their assets, their liquidity is much less and
shows more risk when granting loans.
Bob Smith, Inc.’s failure to meet Cash Balance Requirements
It is concluded that management needed to conduct a thorough analysis of the statement of cash
flows to properly identify if the company met the minimum cash requirements set forth by the
bank. Bob Smith, Inc.’s cash balance was less than $34,000.00 at the end of the period. This is
substantially lower than the $70,000.00 bank requirement.
Based on the financial data of Bob Smith, Inc., it appears that the company’s failure to meet the
cash balance requirements is a direct result of management. Financial data suggests that
management may have prioritized sales over cash, due to the increase in accounts receivable and
inventory. The financial data also indicates that management may have been relying on debt
financing instead of increasing cash flows which ultimately led to the inability to meet the cash
balance requirements set forth.
The Major Portion of the Company’s Working Capital
Bob Smith, Inc.'s working capital appears to have been primarily allocated towards inventory
and accounts receivable. This is evident from the financial data showing an increase in inventory
from $352,740 in 2016 to $423,819 in 2017. Simultaneously, there was a decrease in accounts
receivable from $318,678 to $260,205, suggesting a slower turnover in collecting receivables.
This allocation of working capital towards increasing inventory levels and maintaining a higher
accounts receivable balance indicates a focus on stocking up inventory, possibly at the expense
of liquidity and cash flow efficiency.
Using the 5 C's of Credit in the Loan Decision
To properly assess the level of risk in providing another loan to Bob Smith, Inc. the loan
committee used the 5 C’s (or characteristics) of credit commonly used in the industry to evaluate
the creditworthiness of a firm.
The 5 Cs are character, capacity, capital, conditions, and
collateral. According to Protium (2023), character refers to the borrower’s reputation and credit
history, capacity evaluates their ability to repay debt obligations by analyzing income and the
economic conditions that they function within.
Capital is evaluated by focusing on the overall
financial strength of the company such as the liquidity of assets and how quickly real estate
investments can be sold in case of loan default.
Conditions further evaluate any external
conditions that may negatively impact debt repayments, such as government policy changes,
economic cycles, or advancements in technology.
Lastly, collateral is any asset or real estate
investment/property that can be used as a pledge to secure a loan.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4
Using the 5 C’s of Credit Identifies All of the Correct Weaknesses
The financial analysis for Bob Smith, Inc. suggests there are serious concerns that must be
addressed before providing a new credit facility.
Bob Smith, Inc.'s creditworthiness and
reputation (character) are in question due to the failure to maintain $70,000 in the bank, outlined
in the CC&Rs, and currently meet short-term debt obligations due to a decreased amount of cash
on hand.
Other violations are the increase in Wages Payable account by over 50%, which may
include bonuses that were done without the bank’s explicit approval.
The second factor is
capacity and the potential inability to cover existing long-term debt along with an additional
loan.
External conditions suggest that the company’s inability to effectively recover A/Rs may
suggest ineffective financing terms or a slowed economy.
In analyzing capital and existing
assets, Bob Smith, Inc. has an excessive amount of inventory(PP&E) that is currently 57.1% of
total assets and suggests inefficient inventory management.
This presents another issue as far as
collateral; the majority of assets are non-liquid and cannot be converted into cash quickly
prolonging repayment of the loan.
Financial Analysis to Logically Support the Loan Committee’s Decision
A thorough financial analysis logically supports the decision to not extend a loan to Bob Smith,
Inc. Key concerns include the company's current ratio of 1.83 and quick ratio of 0.81, both
indicating average to low liquidity. The low cash balance of $33,411, compared to the required
$70,000, raises serious concerns about cash management capabilities. Additionally, the
discrepancy between high net income and a minimal increase in cash (only $16,845) suggests
inefficiencies in converting profits into cash. The heavy reliance on inventory (57.1% of total
assets) and a notable increase in long-term debt further underscore potential risks in financial
stability and cash flow management (Parrino et al., 2021)
.
Summary
The decision-making process regarding the loan application of Bob Smith, Inc. is methodically
organized and presented logically. The analysis begins with examining the allocation of working
capital, highlighting inefficiencies in inventory and receivables management. It then transitions
to a detailed financial analysis, scrutinizing liquidity ratios, cash flow, and balance sheet items,
uncovering concerns about cash management and debt reliance. This leads to the application of
the 5 C’s of Credit, which further elucidates the company's creditworthiness issues. The
conclusion, drawn from this sequential and comprehensive evaluation, is a well-founded decision
against extending a loan, aligning with prudent financial lending practices and risk mitigation.
Thank you,
loancommittegroup6@gmail.com
5
Attachments: Bob Smith, Inc. CS Balance Sheet and Statement of Cash Flows.
6
References
Parrino, R., Kidwell, D.S., Bates, T., Gillan, S.L. (2021).
Fundamentals of corporate
finance.
(5
th
ed.). Wiley.
https://purdueuniversityglobal.vitalsource.com/books/978-1-119-79538-4
Partnership Invoice Finance. (2023, June 28)
The importance of a healthy and stable
cash flow for business survival.
LinkedIn.
https://www.linkedin.com/pulse/importance-healthy-stable-cash-flow-business-
survival
Protium. (2023, January 4).
5 cs of credit: comprehending the underwriting process.
LinkedIn.
https://www.linkedin.com/pulse/5-cs-credit-comprehending-
underwriting-process-protiumindia/
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7
Related Questions
MC37
In preparing its August 31, 2020 bank reconciliation, Jade Company has available the following information:
Balance per bank statement, 8/31/2020 — P180,500
Deposit in transit,8/31/2020 — P32,500
Return of costumer's NSF check, 8/31/2020 — P6,000
Outstanding checks, 8/31/2020 — P27,500
Bank service charges for August — P1,000
At August 31, 2020, Jade Company's correct cash balance is? (with solution)
a. P192,500
b. P185,500
c. P179,500
d. P178,500
arrow_forward
Question 2 The following information was taken from the books of Zia Traders on 30 June2019:1. The items appearing on the bank reconciliation statement of Zia Traders asat 31 May 2019.Details Amount(R)Balance as per bank statement (unfavourable) 25 400Outstanding deposit 5 700Outstanding cheques:CHQ116 1 430CHQ135 2 780Correction of incorrect cheque (see note 2.5 below) 570Balance as per bank account ?2. A comparison of the cashbooks for June, the above bank reconciliationstatement and the bank statement for June showed the following:2.1 Provisional totals in the cashbooks on 30 June: Cashbook Receipts R 113 200 Cashbook Payments R 96 0002.2 The outstanding deposit at the end of May for R5 700 appeared onthe bank statement on 5 June 2019.2.3 Cheque number CHQ135 appeared on the bank statement on7 June for R3 100. An investigation revealed that the bankstatement amount was correct.2.4 Cheque number CHQ116 still did not appear on the bank statementfor June 2019. The cheque was…
arrow_forward
about the homework of Intermediate Accounting: Reporting and Analysis 3rd Edition Chapter 6, Problem 17E
arrow_forward
Qestion 1
a) Many loan agreements have financial covenants that rely on:
Multiple Choice
A. floating GAAP.
B. fixed GAAP.
C. flexible GAAP.
D. regulatory accounting procedures (RAP).
b) With respect to executive compensation, the Dodd-Frank Act requires that shareholders:
Multiple Choice
A. vote on executive compensation at least once every three years.
B. vote on executive compensation every fiscal period.
C. determine the annual executive compensation package for key executives.
D. not discuss any aspects of executive compensation with-non shareholders.
arrow_forward
QUESTION 1
The following debtor control account and debtors list were prepared by the owner of Siyadula Traders. The owner is
unsure if he has correctly prepared it.
REQUIRED:
Jse the following information to prepare the correct account and list:
Debtors control account for January 2021
Debtors list at 31 January 2021.
General Ledger
DEBTORS CONTROL ACCOUNT
Jan 01
Balance
b/d
54 300
Jan 31
Bank and discount
CRJ5
36 200
Sales Returns
SRJ
6 200
Sales
SJ
62 110
Balance c/d
37 810
98 310
98 310
Feb 01
Balance
b/d
37 810
Debtors List as at 31 January 2021
Debit
Credit
B. Afleck
12 525
M. Damon
19 085
J. Peter
18 100
A. Paul
9 200
D. Carter
17 900
76 810
arrow_forward
Required information
Exercise 7-5 (Algo) Notes payable—discount basis LO 2
Skip to question
[The following information applies to the questions displayed below.] On April 15, 2019, Powell Inc. obtained a six-month working capital loan from its bank. The face amount of the note signed by the treasurer was $255,400. The interest rate charged by the bank was 5.00%. The bank made the loan on a discount basis.
Exercise 7-5 (Algo) Part b
b. Calculate the amount of interest expense applicable to this loan during the fiscal year ended June 30, 2019.
arrow_forward
Required information
Exercise 7-5 (Algo) Notes payable—discount basis LO 2
Skip to question
[The following information applies to the questions displayed below.] On April 15, 2019, Powell Inc. obtained a six-month working capital loan from its bank. The face amount of the note signed by the treasurer was $255,400. The interest rate charged by the bank was 5.00%. The bank made the loan on a discount basis.
Exercise 7-5 (Algo) Part a - Journal entry
a-3. Record the journal entry to show the effect of signing the note and the receipt of the cash proceeds on April 15, 2019. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)
arrow_forward
EA5-E3 Complete a Bank Reconciliation for Pond
Maintenance Corp.
In this exercise, you will complete a bank reconciliation as of 12/31/2016 for Pond
Maintenance Corp. One of your primary goals is to ensure that the file can be easily under-
stood by the end user. Use this information to populate the reconciliation:
Deposits in Transit: $10,100 and $1,000
• NSF Check: $7,150
Notes Receivable: $7,000
Outstanding Checks: $3,100 and $600
Bank Charges: $1,100
The bank erroneously deposited a $250 check written to TreeSky Industries into the bank
account of Pond Maintenance Corp.
The bank statement reflects a 12/31/16 balance of $94,200, while the company's general
ledger reflects a 12/31/16 cash balance of $102,600.
Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a
conditional formatting rule that will highlight the bank balance if it exceeds $90,000. Apply
a header that displays the filename and file path and a footer that displays the current time.…
arrow_forward
#16
arrow_forward
Part ii. Prepare the journal entries resulting from the bank reconciliation
arrow_forward
SP 6 Serial Problem Business Solutions (Algo) LO P3
Santana Rey receives the March bank statement for Business Solutions on April 11, 2022. The March 31 bank statement shows an
ending cash balance of $67,666. The general ledger Cash account, Number 101, shows an ending cash balance per books of $68,266
as of March 31 (prior to any reconciliation). A comparison of the bank statement with the general ledger Cash account, Number 101,
reveals the following.
a. The bank erroneously cleared a $600 check against the company account in March that S. Rey did not issue. The check was
actually issued by Business Systems.
b. On March 25, the bank statement lists a $57 charge for a safety deposit box. Santana has not yet recorded this expense.
c. On March 26, the bank statement lists a $110 charge for printed checks that Business Solutions ordered from the bank. Santana has
not yet recorded this expense.
d. On March 31, the bank statement lists $36 interest earned on Business Solutions's checking…
arrow_forward
Use the work bank to complete the following
arrow_forward
A bank statement
☐ is a bill from the bank for services rendered
☐
lets a depositor know the financial position of
the bank as of a certain date
О shows the activity which increased or
О
decreased the depositor's account balance
is a credit reference letter written by the
depositor's bank
arrow_forward
ah- ELearning
The proper treatment of outstanding cheques Is to report them in the bank reconcilation as which of the following?
o a. An addition to the balance as per cash book
O b. A deduction from the balance as per bank statement
O C. An addition to the balance as per bank statement
o d. A deduction from the balance as per cash book
A OMR 40,000, interest-bearing notes payable is signed on December 26, 2002. If the note is a 120-day note, what is the maturity date
for this short term liability?
of
O a. April 26
O b. March 25
O c. March 26
O d. April 25
5.
Oman Air purchased aeroplane for OMR 200,000, on July 1, 2015. The company expects the service life of the airplane to be 5 years.
During that time, it is expected that the aeroplane's useful life will be 40,000 hours. The anticipated salvage value is OMR 10,000. The
aeroplane is disposed of after five years of use. Calculate the book value of aeroplane as on 31-12-2017? Use declining-balance
depreciation method of charging…
arrow_forward
Prepare the bank reconciliation of Harvey insurance at December 31, 2024
Journalize any required entries from the bank reconciliation 
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Related Questions
- MC37 In preparing its August 31, 2020 bank reconciliation, Jade Company has available the following information: Balance per bank statement, 8/31/2020 — P180,500 Deposit in transit,8/31/2020 — P32,500 Return of costumer's NSF check, 8/31/2020 — P6,000 Outstanding checks, 8/31/2020 — P27,500 Bank service charges for August — P1,000 At August 31, 2020, Jade Company's correct cash balance is? (with solution) a. P192,500 b. P185,500 c. P179,500 d. P178,500arrow_forwardQuestion 2 The following information was taken from the books of Zia Traders on 30 June2019:1. The items appearing on the bank reconciliation statement of Zia Traders asat 31 May 2019.Details Amount(R)Balance as per bank statement (unfavourable) 25 400Outstanding deposit 5 700Outstanding cheques:CHQ116 1 430CHQ135 2 780Correction of incorrect cheque (see note 2.5 below) 570Balance as per bank account ?2. A comparison of the cashbooks for June, the above bank reconciliationstatement and the bank statement for June showed the following:2.1 Provisional totals in the cashbooks on 30 June: Cashbook Receipts R 113 200 Cashbook Payments R 96 0002.2 The outstanding deposit at the end of May for R5 700 appeared onthe bank statement on 5 June 2019.2.3 Cheque number CHQ135 appeared on the bank statement on7 June for R3 100. An investigation revealed that the bankstatement amount was correct.2.4 Cheque number CHQ116 still did not appear on the bank statementfor June 2019. The cheque was…arrow_forwardabout the homework of Intermediate Accounting: Reporting and Analysis 3rd Edition Chapter 6, Problem 17Earrow_forward
- Qestion 1 a) Many loan agreements have financial covenants that rely on: Multiple Choice A. floating GAAP. B. fixed GAAP. C. flexible GAAP. D. regulatory accounting procedures (RAP). b) With respect to executive compensation, the Dodd-Frank Act requires that shareholders: Multiple Choice A. vote on executive compensation at least once every three years. B. vote on executive compensation every fiscal period. C. determine the annual executive compensation package for key executives. D. not discuss any aspects of executive compensation with-non shareholders.arrow_forwardQUESTION 1 The following debtor control account and debtors list were prepared by the owner of Siyadula Traders. The owner is unsure if he has correctly prepared it. REQUIRED: Jse the following information to prepare the correct account and list: Debtors control account for January 2021 Debtors list at 31 January 2021. General Ledger DEBTORS CONTROL ACCOUNT Jan 01 Balance b/d 54 300 Jan 31 Bank and discount CRJ5 36 200 Sales Returns SRJ 6 200 Sales SJ 62 110 Balance c/d 37 810 98 310 98 310 Feb 01 Balance b/d 37 810 Debtors List as at 31 January 2021 Debit Credit B. Afleck 12 525 M. Damon 19 085 J. Peter 18 100 A. Paul 9 200 D. Carter 17 900 76 810arrow_forwardRequired information Exercise 7-5 (Algo) Notes payable—discount basis LO 2 Skip to question [The following information applies to the questions displayed below.] On April 15, 2019, Powell Inc. obtained a six-month working capital loan from its bank. The face amount of the note signed by the treasurer was $255,400. The interest rate charged by the bank was 5.00%. The bank made the loan on a discount basis. Exercise 7-5 (Algo) Part b b. Calculate the amount of interest expense applicable to this loan during the fiscal year ended June 30, 2019.arrow_forward
- Required information Exercise 7-5 (Algo) Notes payable—discount basis LO 2 Skip to question [The following information applies to the questions displayed below.] On April 15, 2019, Powell Inc. obtained a six-month working capital loan from its bank. The face amount of the note signed by the treasurer was $255,400. The interest rate charged by the bank was 5.00%. The bank made the loan on a discount basis. Exercise 7-5 (Algo) Part a - Journal entry a-3. Record the journal entry to show the effect of signing the note and the receipt of the cash proceeds on April 15, 2019. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)arrow_forwardEA5-E3 Complete a Bank Reconciliation for Pond Maintenance Corp. In this exercise, you will complete a bank reconciliation as of 12/31/2016 for Pond Maintenance Corp. One of your primary goals is to ensure that the file can be easily under- stood by the end user. Use this information to populate the reconciliation: Deposits in Transit: $10,100 and $1,000 • NSF Check: $7,150 Notes Receivable: $7,000 Outstanding Checks: $3,100 and $600 Bank Charges: $1,100 The bank erroneously deposited a $250 check written to TreeSky Industries into the bank account of Pond Maintenance Corp. The bank statement reflects a 12/31/16 balance of $94,200, while the company's general ledger reflects a 12/31/16 cash balance of $102,600. Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a conditional formatting rule that will highlight the bank balance if it exceeds $90,000. Apply a header that displays the filename and file path and a footer that displays the current time.…arrow_forward#16arrow_forward
- Part ii. Prepare the journal entries resulting from the bank reconciliationarrow_forwardSP 6 Serial Problem Business Solutions (Algo) LO P3 Santana Rey receives the March bank statement for Business Solutions on April 11, 2022. The March 31 bank statement shows an ending cash balance of $67,666. The general ledger Cash account, Number 101, shows an ending cash balance per books of $68,266 as of March 31 (prior to any reconciliation). A comparison of the bank statement with the general ledger Cash account, Number 101, reveals the following. a. The bank erroneously cleared a $600 check against the company account in March that S. Rey did not issue. The check was actually issued by Business Systems. b. On March 25, the bank statement lists a $57 charge for a safety deposit box. Santana has not yet recorded this expense. c. On March 26, the bank statement lists a $110 charge for printed checks that Business Solutions ordered from the bank. Santana has not yet recorded this expense. d. On March 31, the bank statement lists $36 interest earned on Business Solutions's checking…arrow_forwardUse the work bank to complete the followingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning