How to Write a Commercial Lending Appraisal Report for Westminster 7FNCE015W
A strong commercial lending report reads like a credit memorandum: it reaches a clear lending decision, supports it with cash flow rather than profit, and states which conditions would make the bank comfortable. If you are working on the 7FNCE015W Global Banking and Lending Assessment 2 at Westminster, this guide shows how to plan the answer to a £60,000 start-up loan case. Need a second opinion on your ratios? Our finance assignment help page explains the support available.
What the assessment is really asking
You take the role of a bank lending officer. The case describes a start-up magazine that has raised £25,000 of equity, is negotiating a two-year £60,000 bank loan and expects a further £100,000 of risk capital. You answer five questions: is the loan a good risk, will the business run short of finance, how easily will repayment be achieved, what security is needed, and how well is the report researched and presented.
The first two questions carry 30 and 23 marks, so about half the marks rest on judgement about risk and cash. Supporting calculations belong in the appendix, and the brief sets the deadline and the rules for declaring any use of generative AI, so read those in your own copy.
A suggested structure
The brief does not prescribe a word split, so use the table as a starting point and scale it to your word limit.
| Report part | Marks | Share of effort | Key content |
|---|---|---|---|
| Executive summary and recommendation | within (e) | 10% | Decision, conditions and the main risk |
| (a) Risk proposition | 30 | 30% | Framework appraisal such as CAMPARI or the 5 Cs |
| (b) Funding shortfall | 23 | 22% | Monthly cash flow and sensitivity tests |
| (c) Repayment | 22 | 20% | Instalments, cover ratios, sources of repayment |
| (d) Security | 13 | 12% | Guarantees, debenture, covenants |
| (e) Presentation and research | 12 | 6% | Theory, referencing and layout, with workings in appendices |
A step-by-step plan
- Read the case twice and list every number: equity, loan, term, price, turnover forecast and the second round of capital.
- Choose a lending framework and use its headings as your section structure for question (a).
- Rebuild the projections as a monthly cash flow, separating operating cash from financing.
- Calculate the instalment and annual debt service before you judge repayment.
- Test the plan with a sales shortfall and a delay in the second equity round.
- Match the security to the assets the business actually has.
- Write the recommendation first, then support it.
- Put the calculations in the appendix and refer to them in the text.
Section-by-section guidance
Is the loan a good risk?
Use a framework so that nothing is missed. CAMPARI covers character, ability, means, purpose, amount, repayment and insurance. The 5 Cs cover character, capacity, capital, collateral and conditions. Either works, provided you apply each heading to the case and reach a verdict, not just define the letters.
Calculate gearing early. A £60,000 loan against £25,000 of equity is 2.4 times equity, which is 70.6% of total funding, so the bank carries most of the risk. If the extra £100,000 arrives as equity, the figure changes sharply, and you should show both versions.
Will the project run short of finance?
A profit forecast will not answer this. Build a monthly cash flow that shows when printing, distribution and promotion costs are paid compared with when sales money arrives. New magazines often face returns of unsold copies and slow settlement from distributors, so state your assumptions.
Then stress it. Reduce sales by 10% to 20% and delay the second equity round by six months. The question asks whether additional funding is likely, so say clearly where and when the gap appears.
How easily will repayment be achieved?
Calculate the monthly instalment from the loan amount, rate and term. Then divide annual operating cash flow by annual debt service. A ratio below one means the business cannot repay from trading, and many lenders want comfortably more than one.
Name the sources of repayment: operating cash flow, new equity and, as a last resort, security. A report that identifies a weak first source and proposes a restructured term shows real credit judgement. For a worked illustration, see our commercial lending appraisal model answer, for reference only. It uses illustrative figures, so build your own from the case pack.
What security should the bank request?
Be realistic. A start-up publisher has few tangible assets, so a property charge is unlikely. Typical elements are a debenture over the company’s assets, a personal guarantee from the founder, assignment of key person insurance and covenants such as minimum cash and monthly reporting. Explain why each is proportionate to the risk, and note that a guarantee is only as strong as the guarantor’s own assets.
Why students lose marks on this report
The usual pain point is that the numbers and the narrative do not match. A report may praise the management team and then show a cash flow that goes negative in month three, with no comment on the conflict. Another is spending the word count describing the business in the case when the marker wants analysis of risk. Finally, many students leave the appendix to the last hour, so the workings contain errors that undermine an otherwise sound argument. Build the calculations first, and write the report around what they show.
What a higher-scoring answer looks like
| Weaker sentence | Stronger sentence |
|---|---|
| The business is forecast to be profitable. | The business is forecast to be profitable, but cash is negative in the first year because costs are paid before sales are collected. |
| The loan is risky because it is a start-up. | Debt is 70.6% of total funding, so the bank carries most of the risk while the equity holder carries little. |
| The company can repay the loan. | Operating cash covers only 0.9 times annual repayments, so repayment depends on the second equity round. |
| The bank should take security. | The bank should take a debenture and a limited personal guarantee, because the company has few tangible assets. |
For help structuring the report itself, our report writing help page covers executive summaries, appendices and layout.
Mark-maximising checklist
- The executive summary states a decision and its conditions.
- A named lending framework is applied heading by heading.
- Gearing is calculated and interpreted.
- The cash flow is monthly and separates operating and financing flows.
- At least two sensitivity tests are shown.
- The instalment and debt service cover are calculated, not estimated.
- Non-financial factors such as management, market and competition are discussed.
- Security matches the assets the company really has.
- Calculations are in the appendix and cross-referenced.
- Referencing is consistent and sources are real.
Common mistakes
- Treating profit as cash. Banks are repaid in cash, so a profit forecast alone proves little.
- Ignoring the timing of equity. Money promised later cannot pay costs now.
- Listing a framework without a verdict. Each heading should end with an assessment.
- Unrealistic security. Asking for property the company does not own shows weak judgement.
- Missing the investor angle. The offer of a 31.25% share for £100,000 implies a value you can comment on.
- Calculations hidden in the appendix. The text must carry the conclusion, even if the working sits elsewhere.
Common student worries
“The case does not give every number.” Say what you have assumed and why. Markers reward clear assumptions more than silent guesses.
“I am not sure whether to approve the loan.” You can approve, decline or approve with conditions. The most defensible answer is often a conditional approval with staged drawdown, provided you explain the risks it controls.
“How much theory is enough?” Use theory to explain a decision, such as why information problems make lenders ask for security. For more on how we support banking and finance work at this level, see about our editorial team and the Westminster University assignment help page.
FAQs
Should I recommend approving the loan?
Whichever answer you choose, support it with numbers. A conditional approval, with staged drawdown and security, is often the most realistic outcome for a start-up with high gearing.
What interest rate should I assume?
Use the rate in the case if there is one. If there is none, state a clearly labelled assumption, show how the repayment changes under a higher rate and keep the same rate throughout.
How do I calculate the monthly instalment?
Use the annuity formula: the loan multiplied by the monthly rate, divided by one minus the monthly rate plus one raised to the negative number of months. Show the formula and the inputs in the appendix.
Does the Enterprise Investment Scheme matter?
It can. The scheme gives tax reliefs to investors in qualifying companies, which may help the company attract the second round of capital. Treat that capital as uncertain until it is actually paid in.
How many marks go on calculations?
The brief spreads calculations across questions (a) to (d) rather than awarding one block, so accuracy affects several answers. Check your own marking criteria for the details.
What belongs in the appendix?
Put the cash flow, ratio workings, instalment calculation and sensitivity tables there, and refer to each one by number in the main text.
If you are short of time before the deadline, send your brief through our submit assignment page and we will advise on the next step.




