OECS Bank has both a loans division and mutual funds division. It has allocated $40.0M to finance its loan portfolio. Its operations manager is asked to build an LP model to help guide company decisions as to how to disburse the revolving fund across different loan categories. The operations manager garnered the following data on available types of loans based on market research of the industry: Types of Loan Interest Rate Bad Debt Ratio Personal 0.15 .10 Car 0.20 0.04 Home 0.17 0.02 Small and medium enterprises 0.25 0.15 Commercial 0.10 0.02 The Bank’s net return is interest rate net of Bad debt. Revenue from interest is gained only from good loans. a) Generate the objective function using your variables from above b) Generate the total budget constraint c) The bank allocates at least 45% of the funds to SMEs and Commercial loans. d) Home loans must equal at least 50% of the personal, car and homes loans. e) The bank also has a stated policy of not allowing the overall ratio of bad debts on all loans to exceed 5 %. g) Generate the non-negative constraint

OECS Bank has both a loans division and mutual funds division. It has allocated $40.0M to finance its loan portfolio. Its operations manager is asked to build an LP model to help guide company decisions as to how to disburse the revolving fund across different loan categories. The operations manager garnered the following data on available types of loans based on market research of the industry: Types of Loan Interest Rate Bad Debt Ratio Personal 0.15 .10 Car 0.20 0.04 Home 0.17 0.02 Small and medium enterprises 0.25 0.15 Commercial 0.10 0.02 The Bank’s net return is interest rate net of Bad debt. Revenue from interest is gained only from good loans. a) Generate the objective function using your variables from above b) Generate the total budget constraint c) The bank allocates at least 45% of the funds to SMEs and Commercial loans. d) Home loans must equal at least 50% of the personal, car and homes loans. e) The bank also has a stated policy of not allowing the overall ratio of bad debts on all loans to exceed 5 %. g) Generate the non-negative constraint

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter16: Working Capital Policy And Short-term Financing

Section: Chapter Questions

Problem 23QTD

See similar textbooks

Similar questions

OECS Bank has both a loans division and mutual funds division. It has allocated $40.0M to finance its loan portfolio. Its operations manager is asked to build an LP model to help guide company decisions as to how to disburse the revolving fund across different loan categories. The operations manager garnered the following data on available types of loans based on market research of the industry: Types of loan Interest rate Bad debt ratio Personal 0.15 .10 Car 0.20 0.04 Home 0.17 0.02 Small and medium enterprises 0.25 0.15 Commercial 0.10 0.02 The Bank’s net return is interest rate net of Bad debt. Revenue from interest is gained only from goodloans. d) Home loans must equal at least 50% of the personal, car and homes loans.e) The bank also has a stated policy of not allowing the overall ratio of bad debts on all loans to exceed 5 %. g) Generate the non-negative constraint
(Ratio Computation and Analysis; Liquidity) As loan analyst for Utrillo Bank, you have been presented the following information. Check the image for information. Each of these companies has requested a loan of $50,000 for 6 months with no collateral offered. Because your bank has reached its quota for loans of this type, only one of these requests is to be granted.InstructionsWhich of the two companies, as judged by the information given above, would you recommend as the better risk and why? Assume that the ending account balances are representative of the entire year.
Cash Balance Sheet Marketable securities Account receivable Inventory Prepaid rent Total current assets Net Plant and equipment Total assets Account payable Notes payable Accruals Total current liabilities Long-term debt Common stockholders' equity Total liabilities and stockholders' equity Sales Less; Cost of goods sold Gross profit Less: General and administrative Less: Interest Less: Depreciation Total operating and interest expense Earning before tax Less: tax Net income Less: cash dividend Change in retained earnings James Company 2015 15,000 6,000 42,000 51,000 1,200 115,200 286,000 401,200 48,000 15,000 6,000 69,000 160,000 172,200 401,200 2016 14,000 6,200 33,000 84,000 1,100 138,000 270,000 408,300 57,000 13,000 5,000 75,000 150,000 183,300 408,300 600.00 460.000 140.000 30.000 10.000 30.000 70.000 70.000 27.100 42.900 31.800 11.100
Information concerning the allocation of loan portfolios to different market sectors is given below: Allocation of Loan Portfolios in Different Sectors (%) Sectors National Bank A Bank B Commercial 30% 50% 10% Consumer 40% 30% 40% Real Estate 30% 20% 50% Question: What’s the portfolio deviation from the national average for Bank A and Bank B, respectively?
A thrift has an annual CGAP of -$25 million. A credit union has an annual CGAP of +$5 million. The thrift has total assets of $500 million and net income of $7.5 million and the credit union has total assets of $40 million and net income of $0.7 million. Calculate each institution's CGAP as a percent of assets. Based on the gap, which institution's NII is more sensitive to interest rates?
The financial system can be best described as:A. A computer system that is used to process trades/transactions byparticipants in financial markets and/or institutions.B. Financial markets plus institutions.C. Participants and players in financial markets and the direct route forchanneling funds in the economy from the surplus agents to deficitagents.2. Ion National Bank issues a 6-month, USD 1 million CD at 4.0% andfunds a loan in Argentine pesos (ARS) at 6.5%. The spot rate for theARS was ARS 2.27 per USD at the time of the transaction. In 6 months,the ARS will have depreciated to ARS 2.30 per USD. What is therealized nominal annual spread on the loan?A. -1.07%B. -0.19%C. 0.11%3. Based on semiannual compounding, what would the price be of a 13-year, 10% coupon, and $1,000 par value bond that is currently yielding9.25%? A. 1,036.03 B. 1,055.41 C. 1,056.05 4. What is the price of a T-bill that has a bank discount yield of 5%, a$100,000 face value and a 180 day holding…
You are a credit analyst of a growing commercial bank and have recently received loan applications from two companies of relatively similar size. Show below are selected financial data for these two applicants at the end of the current year: RED CO BLUE CO. Net credit sales P700.000.00 P650,000.00 Cost of goods sold P500,000.00 P490,000.00 Cash P60,000.00 P20,000.00 Accounts receivable (net) P77,000.00 P60,000.00 Inventory P94,000.00 P180,000.00 Current liabilities P11000.00 P105,000.00 Assume that the year-end balances for accounts receivable and for inventory approximate the average balances of these items throughout the year. A. Compute the following on BLUE 1. Working capital 2. Current ratio 3. Acid test ratio
To assist in approaching the bank about the loan, Paul has asked you to compute the following ratios for both this year and last year. The amount of working capital The current ratio The acid-test ratio The average collection period (The accounts receivable at the beginning of last year totaled $250,000) The average sales period (The inventory at the beginning of last year totaled $500,000) The operating cycle The total asset turnover. (The total assets at the beginning of last year were $2,420,000) The debt-to-equity ratio The times interest earned ratio The equity multiplier (The total stockholder’s equity at the beginning of last year totaled $1,420,000) 2. For both this year and last year A. Present the balance sheet in common-size format B. Present the income statement in common-size format down through net income Could you please help me answer Question 10, 2A, and 2B?
To assist in approaching the bank about the loan, Paul has asked you to compute the following ratios for both this year and last year. The amount of working capital The current ratio The acid-test ratio The average collection period (The accounts receivable at the beginning of last year totaled $250,000) The average sales period (The inventory at the beginning of last year totaled $500,000) The operating cycle The total asset turnover. (The total assets at the beginning of last year were $2,420,000) The debt-to-equity ratio The times interest earned ratio The equity multiplier (The total stockholder’s equity at the beginning of last year totaled $1,420,000) 2. For both this year and last year A. Present the balance sheet in common-size format B. Present the income statement in common-size format down through net income Could I please have somed help with Question 10 with a breakdown of the explanation?
To assist in approaching the bank about the loan, Paul has asked you to compute the following ratios for both this year and last year. The amount of working capital The current ratio The acid-test ratio The average collection period (The accounts receivable at the beginning of last year totaled $250,000) The average sales period (The inventory at the beginning of last year totaled $500,000) The operating cycle The total asset turnover. (The total assets at the beginning of last year were $2,420,000) The debt-to-equity ratio The times interest earned ratio The equity multiplier (The total stockholder’s equity at the beginning of last year totaled $1,420,000) Could you please help me answer 7-9?
Snowflake Manufacturing [SM] has recently come to the bank you work for looking for a $280,000 long-term loan. The following data was submitted with SM's loan application: 2020 $475,200 155,400 175,200 408,600 103,500 13,200 34,200 56,100 64,200 2019 $316,500 120,000 2021 $820,800 Current assets.. Current liabilities. Non-current liabilities. Shareholders' equity.. Operating income... Interest expense... Income tax expense.. Net income... 414,600 60,800 303,700 168,900 7,200 65,400 96,300 106,300 300,000 490,200 208,500 28,500 72,000 108,000 115,000 Operating cash flow... The loan committee has asked you to analyze the data using at least three relevant financial ratios and complete a brief trend analysis. They would also like you to briefly discuss any limitations that might exist when completing this type of analysis and what data dashboards can do to help this. Finally, they have asked that your report also contain a recommendation about whether SM's loan request should be approved.…
Please answer it within 45mins,it would be helpful!!! Which pair of ratios would provide the MOST USEFUL information to a bank providing a long-term loan to a business? Group of answer choices: Gearing and interest cover Return on equity and EPS Asset turnover and ration of expenses to sales ROCE and gross profit margin