Produce a credit memorandum

Assignment Help Financial Management

Reference no: EM131350682

Credit Memorandum

Task
Request from customer
You are employed as a Senior Business Banking Manager at the Asian Infrastructure Development Bank Ltd. The directors of Lithgow Valley Coal Pty Ltd have approached you for additional funding.

The company has now requested an increase in their existing leasing facility from $2,500,000 to $3,000,000 to purchase additional equipment and machinery and overdraft facility from $350,000 to $500,000 to fund research and development.

The company has been successful in winning several new contracts from around the country and is expected to increase revenue by 20 percent next year followed by 10 percent growth in the 4 years after that, mainly due to lower cost of fossil fuel compared to alternative sources of energy. Kevin estimates the operating cost will only increase by 5 percent per annum over the next 5 years.

The company also has Term Debt with current outstanding amount of $2,856,750 as per 2016 balance sheet with remaining term of 12 years to repay this debt in full.

Existing and increased facilities will be secured by way of all three director's personal guarantees and General Security Agreement over the company's assets. Net worth of the directors is estimated around $2 million each.

You are required to to produce a credit memorandum (credit approval report) to seek approval from your credit manager for the request from the client in the following scenario.

Background/History
Established in 1989, Lithgow Valley Coal Pty Ltd is a coal mining and marketing company supplying thermal and coking coal to the domestic market.

Lithgow Valley Coal, which has over 200 employees, is a medium size underground coal producer in NSW. The company sees its future through organic growth at their existing operations and focuses on the Company's portfolio management including acquisitions, divestments and focused exploration.

Vision
To be the leading, sustainable Australian coal supplier to both domestic and export markets.

Our mission
To operate and grow a sustainable mining business, delivering value to our customers and our shareholders whilst at the same time exceeding the expectations of our stakeholders.

Values
Principles are integral to our business as we:
• Strive for financial and operational excellence
• Refuse to compromise on safety
• Listen to, understand and provide opportunities for our employees
• Communicate honestly and openly with our stakeholders at all times
• Encourage innovation
• Strive for synergy by collaboration
• Value our corporate reputation and social licence to operate and strive to be a good corporate citizen

To be sustainable we must:
• Seek zero harm to people and the environment
• Productively and efficiently mine quality coal
• Increase Company value
• Leave a community with greater capacity than when we arrived
• Attract, develop, motivate and retain a diverse workforce
• Maximise the value of the resources we use
• Secure new resources

Note: The above background, vision, mission statement etc has been sourced from the website of Centennial Coal to give you the feel of real world scenario. https://www.centennialcoal.com.au/About-Us/Who-We-Are.aspx

Management
Kevin Ure, Timothy Brown and Sara Young are major shareholders and directors of Lithgow Valley Coal Pty Ltd. Sara is the Managing Director, Timothy has an engineering background and manages the research and developments whereas Kevin looks after the operations and finance. The company also employs 4 full time admin staff members apart from around 200 miners on contracts.

Required for assessing serviceability in your Credit Memorandum
1. You are to calculate principal and interest repayments based on the affordability interest rate of 8.5% p.a. on the Overdraft and Term Debt facility and 7.5% p.a. on Leasing facility over 15 years term for Over Draft and 7 years for leasing facility.

2. You are to include the following structure as a minimum in your credit memorandum. Additional materials on credit memorandum template and identifying risk and mitigant is attached on the Subject site's Resources.
• Customer and industry background information.
• Risk identification and mitigants.
• Financial Analysis (Key ratio analysis working along with commentary required i.e. liquidity ratio, efficiency ratio, profitability ratio and leverage ratio for 2014, 2015 & 2016).
• Debt Serviceability calculation.
• Cash flow analysis.

Hint:
i. Ratios are of no value when looked in isolation. They need to be compared with and against other information such as trends and must always be connected back to the cause in the trend.

ii. When you review the financial ratios, you should be able to paint a picture of the business as to its financial strengths, weakness, opportunity and threats.

• Rationale for recommendation with commentary on primary and secondary exits.
• Overall flow and structure of the credit memorandum.

Any data you use in your proposal must be referenced from a reliable source i.e. industry reports etc. Additional materials on credit memorandum template and identifying risk and mitigant is attached on the subject's Resources.

Lithgow Valley Coal Pty Ltd

	Detailed Financials for year end ($)
	2014	2015	2016
ASSETS
Current Assets
Cash	231,750	171,250	23,650
Accounts Receivable - Trade	2,808,880	3,117,030	3,526,900
Account Receivable - Other	5,190	17,480	21,850
Inventory/Stock in Trade	1,846,770	2,017,020	2,275,470
Prepaid Expenses	29,750	72,910	40,860
TOTAL CURRENT ASSETS	4,922,340	5,395,690	5,888,730
Fixed Assets
Land	1,115,000	1,115,000	1,115,000
Building & Improvements	1,248,250	1,348,250	1,348,250
Furniture & Fixtures	47,850	71,480	57,080
Machinery & Equipment	597,980	626,180	2,007,880
Computers and Office equipment	86,400	77,300	74,610
Transportation Equipment	252,830	322,970	335,940
Due from Related Parties	14,250	27,250	139,650
Patents	45,250	45,250	45,250
TOTAL NON-CURRENT ASSETS	3,407,810	3,633,680	5,123,660
TOTAL ASSETS	8,330,150	9,029,370	11,012,390

Lithgow Valley Coal Pty Ltd

	Detailed Financials for year end ($)
	2014	2015	2016
LIABILITIES
Current Liabilities
Overdraft	427,560	526,820	328,450
Current Mat - Finance Lease/ HP Liabilities	128,360	135,460	461,350
Accounts Payable - Trade	1,732,650	1,772,600	2,531,570
Accounts Payable - Other	112,640	154,080	175,850
Accrued Liablities	14,600	20,310	79,250
Provisions - GST	212,680	163,520	145,780
TOTAL CURRENT LIABILITIES	2,628,490	2,772,790	3,722,250
Long Term / Non Current Liabilities
Long Term Debt - Financial Institution	2,563,240	2,758,420	2,856,750
Long Term Debt - Finance Lease/ HP Liabilities	372,150	399,110	1,563,580
Due to Shareholders	1,024,960	769,240	788,900
Other non current provisions	62,250	110,810	165,470
TOTAL SENIOR LT LIABILITIES	4,022,600	4,037,580	5,374,700
TOTAL LIABILITIES	6,651,090	6,810,370	9,096,950
NET WORTH
Paid Up Capital / Ordinary Shares	100	100	100
Profit & Loss A/c or Firms Capital A/c	1,678,960	2,218,900	1,915,340
NET WORTH	1,679,060	2,219,000	1,915,440
TOTAL LIABILITIES & NET WORTH	8,330,150	9,029,370	11,012,390

Lithgow Valley Coal Pty Ltd

	Detailed Financials for year end ($)
	2014	2015	2016
INCOME STATEMENTS
SALES	13,525,850	14,752,580	16,001,240
Cost of Goods Sold	8,813,450	9,753,850	11,633,740
GROSS PROFIT/ REVENUES	4,712,400	4,998,730	4,367,500
General & Administrative Expense	2,598,870	2,929,580	2,999,740
Selling Expenses	76,420	123,480	182,140
Wages & Salaries	768,830	784,400	928,780
Compensation	70,960	60,620	49,350
Bad Debt	41,760	52,480	62,540
Depreciation	70,270	90,030	200,630
TOTAL OPERATION EXPENSES	3,627,110	4,040,590	4,423,180
TOTAL OPERATING PROFIT	1,085,290	958,140	-55,680
Interest Income	19,870	23,650	11,780
Interest Expense	171,250	167,680	214,820
Interest Expenses Lease/Hire Purchase	45,280	48,120	55,280
PROFIT BEFORE TAXES & EXTRA ITEM	888,630	765,990	-314,000
Current Taxes	270,860	222,800	-880
Gain/(Loss) on Sale of Assets	11,250	-3,250	9,560
NET PROFIT	629,020	539,940	-303,560

Rationale

This assignment is designed to:

Assess your progress towards meeting the subject learning outcomes 1, 2 and 3.
allow you to demonstrate your understanding of Topics 1 to 6;
assist you to develop knowledge and skills required to operate professionally in the banking and financial institutional lending environment;
allow you to develop your understanding of sound and practical lending techniques including risk analysis;
demonstrate your understanding of the key criteria used in such analysis;
develop credit writing skills.

Presentation

Credit Memorandum

You are to include the following structure as a minimum in your credit memorandum. Additional materials on credit memorandum template and identifying risk and mitigant is attached on the Subject site's Resources.

Customer and industry background information.
Risk identification and mitigants.
Financial Analysis (Key ratio analysis working along with commentary required i.e. liquidity ratio, efficiency ratio, profitability ratio and leverage ratio for 2014, 2015 & 2016).
Debt Serviceability calculation.
Cash flow analysis.
Rationale for recommendation with commentary on primary and secondary exits.
Overall flow and structure of the credit memorandum.

Credit memorandum will be assessed on the overall quality and conciseness of your response.

Requirements

As per the CSU Referencing Policy, each assessment item must indicate the style of referencing required for each task. Students should be directed to a single Guide that supports the required referencing style for each assessment task. For those tasks requiring the use of APA, students should be directed to the CSU Referencing website at https://student.csu.edu.au/study/referencing-at-csu

For this assessment you are required to use APA referencing to acknowledge the sources that you have used in preparing your assessment.

Please refer to the CSU referencing guide https://student.csu.edu.au/study/referencing-at-csu.

In addition a very useful tool for you to use that demonstrates how to correctly use in text referencing and the correct way to cite the reference in your reference list can be found at https://apps.csu.edu.au/reftool/apa-6

Reference no: EM131350682

Questions Cloud

Find the minimum number of propellers : find the minimum number of propellers required to move at a speed of 35 mph, and the torque in each shaft.

Chances of risk events occurring : The chances of risk events occurring and their respective costs increasing change over the project life cycle. What is the significance of this phenomenon to a project manager?

What if the descendants of the ring come forward : A 10 karat emerald ring was found on a sunken ship from the year 1622 by divers off the coast of Florida. The ship sank due to a hurricane. The ring is valued at $500,000. What sort of property is the ring? Lost, abandoned, or mislaid? Why? Who owns ..

Carefully evaluate solutions before implementing : Do you always carefully evaluate a solution before implementing? At work or at home do you carefully evaluate solutions before implementing

Produce a credit memorandum : Produce a credit memorandum (credit approval report) to seek approval from your credit manager for the request from the client in the following scenario.

Salvage value at the end of the project : CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $489,000 is estimated to result in $188,000 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Ta..

What is sampling and why do we need sampling : What is sampling and why do we need sampling? What are the common sampling methods? Could you provide a real world example to illustrate which method is more appropriate to choose in reality? What are your criteria?

Consider the apple watch series 2 : Consider the Apple Watch Series 2 (picture shown above). The users of iPhones have a choice of interacting with an Apple Watch (assuming the user owns both) to perform some tasks where they have a choice of using the iPhone or the Apple Watch.

Describing and justifying a high-level project management : Describing and justifying a high-level project management methodology that could be applied to a project from a selected case study.

User Account

All Pages