Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. QUESTION SITUATION: You do know that the lender has risk rated these loans as Pass/Watch. You are not able to determine the current financial

image text in transcribed

. QUESTION SITUATION: You do know that the lender has risk rated these loans as Pass/Watch. You are not able to determine the current financial condition of the borrower to rate it otherwise. If you don't have current financials and the loan is delinquent, you should risk rate it Special Mention or worse. You will be asked to determine an independent risk rating for each loan (Pass, Special Mention. Substandard or Doubtful). You may review these and determine a risk rating that is different from the Pass/Watch rating of the bank. Once you have made your assessment and decision, briefly summarize your justification for each rating. There are two questions: Riverview Dental and Big Bear Motel 1) Riverview Dental Outstanding Unfunded Commitment Bank Risk Rating Student Risk Rating 1 1 $7,500,000 $2.500.000 Pass Sales Operating profit Net income Depreciation Interest Cashflow before distributions Cash Distributions CF after distributions Total debt service DSCR An analysis of the last three years Financial Statement, plus the last period end is as follows: 12/31/17 12/31/18 12/31/19 $5,432K $10,789 $29,312K 5186K 5276K 5330K $479 $(122)K $(84) $124K $233% $155K $393% $415K $217K $996K $526K $288K 8/31/20 $21.508K 51,828K $1,0BOK Sa. 0 $193K $1,273K $134K 562K $224K 5297K $862K $64K More $1,2SOK $393K $415K $217K $193K 2 194 112 0.29% 5.764 Per the bank spreads of the 12/31/19 company prepared Financial Statement, A/R days have increased to 57 days, up from 6 days at 12/18,36 days at 12/17 and 37 days at 12/16. Accounts Payable (A/P) days have also increased to 34 days at 12/31/19 from 3 days at 12/18, 10 days at 12/17 and 5 days at 12/16 A monthly borrowing base certificate (BBC) is required. Per the Bank, no over-advances were noted during the last 12 months No collateral audit is required. The BBCreceived as of 12/31/19 reflected the following Borrower Synopsis John Smith is a dentist in Culver City, CA. Loan Description: This revolving line of credit was established in 2011 for the purpose of buying out Mr. Smith's partner, Mr. Collins. This line provided funds to purchase the partnership assets totaling $7.9MM and to provide a working capital line for future equipment needs. The primary source of repayment (PSOR) is cash flow from the business with a required monthly borrowing base certificate (BBC). Margin 75% Allowable Value $3,785K Appraisaldate N/A Stated Value A/R.net of $494K over 90 55,046K days Equipment $10,769K Total Value 65% N/A $7,000K 510,785K The secondary source of repayment is liquidation of the pledged collateral. Collateral consists of eligible Accounts Receivables (A/R) and dental equipment. Terms of repayment call for interest only monthly at the Bank's prime rate plus 1%, with a floor of 5% and principal due at maturity. Per the loan history dated 8/31/20 the loan has paid as agreed over the last 12 months Big Bear More Outstanding 1 $2.500 Unfunded commitment 50 Bank Risk Rating Student Risk Rating The Bank's risk roting is based on the following: The PSOR appears to support the debt. Per the bank's spreads of the borrower prepared 12/31/19Financial Statement, cash available to service debt of $1,250K, after cash distributions, was sufficient to support required interest payments of $193k for a 6.47x interest coverage ratio. Assuming the bank termed out the 57,500K outstanding balance at 5% for seven years, the resulting $1,020K in annual Principle and Interest (P&I) would be covered by the $1,250K cash available to service debt for a 1.22x debt service coverage ratio. However, the prior years' available Company Finance (CF) of S9SOK would not have supported a term out using this hypothetical structure. The borrowing base certificate as of 12/31/19 showed a total eligible borrowing base of $10,78SK, limited to the commitment amount of $10MM, compared to the 8/31/20 outstanding balance of $7,500K for excess availability of $2,500K. The cash value at ledeed life insurance policies of $235K latter an 80% marginad additional support The Personal Financial Statement(PFS) dated 5/19/20 listed cash on hand of $600K and marketable securities of $75K. a Net Worth (NW) of $28.8M largely centered in the equipment value of the dental practice of $17.SMM (pledged to the borrower's loan and Real Estate (RE) of SEMM. The guarantor's only debt was a real estate mortgage of 5801K Yohastification for their risk rating Borrower Synopsis The borrower was formed to own and operate a 110 room hotel in Big Bear, The borrower is owned by Robert and Julia Barnes, real estate Investors Loan Description The loan originated in August 2016 for the purpose of acquiring this property. The primary source of repayment (PSOR is operating income. The loan is secured by a trust deed on the property and the liquidation of collateral and guarantor support. Mr. and Mrs. Barnes provide unlimited guarantees. In 2018 the interest rate was lowered from 106.5%. Current terms call for Principle & Interest payments (P) monthly of 521,372 amorised over 25 years with Sfive year maturity. The loan is current The son's risk roting is based on the following: . Borrower history shows no delinquendies. However, a note to file indicates that the borrowers have asked for a further rate reduction to ease cash flow . Although a current Financial Statement has not been received the PSOR appears to exceed debe service requirements based on the loan officer's note to file that the current 70% occupancy rate results in a 110 the Debt Service Coverage ROSCR) Property taxes are current The July 2016 april shows a Net Operating Income INOT of $30K with an acapat, reitingin 54,155K appraised value and a 67% of Lonto Value (LTV) The last guarantor Financial Statement dated ve 2020 showed a NW of SM Centered in Real Estate Investments of S7M,marketable securities of $2.5M and cash on hand of SSOOK . . QUESTION SITUATION: You do know that the lender has risk rated these loans as Pass/Watch. You are not able to determine the current financial condition of the borrower to rate it otherwise. If you don't have current financials and the loan is delinquent, you should risk rate it Special Mention or worse. You will be asked to determine an independent risk rating for each loan (Pass, Special Mention. Substandard or Doubtful). You may review these and determine a risk rating that is different from the Pass/Watch rating of the bank. Once you have made your assessment and decision, briefly summarize your justification for each rating. There are two questions: Riverview Dental and Big Bear Motel 1) Riverview Dental Outstanding Unfunded Commitment Bank Risk Rating Student Risk Rating 1 1 $7,500,000 $2.500.000 Pass Sales Operating profit Net income Depreciation Interest Cashflow before distributions Cash Distributions CF after distributions Total debt service DSCR An analysis of the last three years Financial Statement, plus the last period end is as follows: 12/31/17 12/31/18 12/31/19 $5,432K $10,789 $29,312K 5186K 5276K 5330K $479 $(122)K $(84) $124K $233% $155K $393% $415K $217K $996K $526K $288K 8/31/20 $21.508K 51,828K $1,0BOK Sa. 0 $193K $1,273K $134K 562K $224K 5297K $862K $64K More $1,2SOK $393K $415K $217K $193K 2 194 112 0.29% 5.764 Per the bank spreads of the 12/31/19 company prepared Financial Statement, A/R days have increased to 57 days, up from 6 days at 12/18,36 days at 12/17 and 37 days at 12/16. Accounts Payable (A/P) days have also increased to 34 days at 12/31/19 from 3 days at 12/18, 10 days at 12/17 and 5 days at 12/16 A monthly borrowing base certificate (BBC) is required. Per the Bank, no over-advances were noted during the last 12 months No collateral audit is required. The BBCreceived as of 12/31/19 reflected the following Borrower Synopsis John Smith is a dentist in Culver City, CA. Loan Description: This revolving line of credit was established in 2011 for the purpose of buying out Mr. Smith's partner, Mr. Collins. This line provided funds to purchase the partnership assets totaling $7.9MM and to provide a working capital line for future equipment needs. The primary source of repayment (PSOR) is cash flow from the business with a required monthly borrowing base certificate (BBC). Margin 75% Allowable Value $3,785K Appraisaldate N/A Stated Value A/R.net of $494K over 90 55,046K days Equipment $10,769K Total Value 65% N/A $7,000K 510,785K The secondary source of repayment is liquidation of the pledged collateral. Collateral consists of eligible Accounts Receivables (A/R) and dental equipment. Terms of repayment call for interest only monthly at the Bank's prime rate plus 1%, with a floor of 5% and principal due at maturity. Per the loan history dated 8/31/20 the loan has paid as agreed over the last 12 months Big Bear More Outstanding 1 $2.500 Unfunded commitment 50 Bank Risk Rating Student Risk Rating The Bank's risk roting is based on the following: The PSOR appears to support the debt. Per the bank's spreads of the borrower prepared 12/31/19Financial Statement, cash available to service debt of $1,250K, after cash distributions, was sufficient to support required interest payments of $193k for a 6.47x interest coverage ratio. Assuming the bank termed out the 57,500K outstanding balance at 5% for seven years, the resulting $1,020K in annual Principle and Interest (P&I) would be covered by the $1,250K cash available to service debt for a 1.22x debt service coverage ratio. However, the prior years' available Company Finance (CF) of S9SOK would not have supported a term out using this hypothetical structure. The borrowing base certificate as of 12/31/19 showed a total eligible borrowing base of $10,78SK, limited to the commitment amount of $10MM, compared to the 8/31/20 outstanding balance of $7,500K for excess availability of $2,500K. The cash value at ledeed life insurance policies of $235K latter an 80% marginad additional support The Personal Financial Statement(PFS) dated 5/19/20 listed cash on hand of $600K and marketable securities of $75K. a Net Worth (NW) of $28.8M largely centered in the equipment value of the dental practice of $17.SMM (pledged to the borrower's loan and Real Estate (RE) of SEMM. The guarantor's only debt was a real estate mortgage of 5801K Yohastification for their risk rating Borrower Synopsis The borrower was formed to own and operate a 110 room hotel in Big Bear, The borrower is owned by Robert and Julia Barnes, real estate Investors Loan Description The loan originated in August 2016 for the purpose of acquiring this property. The primary source of repayment (PSOR is operating income. The loan is secured by a trust deed on the property and the liquidation of collateral and guarantor support. Mr. and Mrs. Barnes provide unlimited guarantees. In 2018 the interest rate was lowered from 106.5%. Current terms call for Principle & Interest payments (P) monthly of 521,372 amorised over 25 years with Sfive year maturity. The loan is current The son's risk roting is based on the following: . Borrower history shows no delinquendies. However, a note to file indicates that the borrowers have asked for a further rate reduction to ease cash flow . Although a current Financial Statement has not been received the PSOR appears to exceed debe service requirements based on the loan officer's note to file that the current 70% occupancy rate results in a 110 the Debt Service Coverage ROSCR) Property taxes are current The July 2016 april shows a Net Operating Income INOT of $30K with an acapat, reitingin 54,155K appraised value and a 67% of Lonto Value (LTV) The last guarantor Financial Statement dated ve 2020 showed a NW of SM Centered in Real Estate Investments of S7M,marketable securities of $2.5M and cash on hand of SSOOK

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

Finance For Non Financial Managers

Authors: Pierre Bergeron

6th Edition

0176501630, 9780176501631

More Books

Students also viewed these Finance questions

Question

=+f. Does it promise a benefit or solve a problem?

Answered: 1 week ago

Question

=+ Why do some seem like a personalized, individual message?

Answered: 1 week ago