📘 Uncategorized

Harvey Norman Ratio Analysis Assignment

AD adminblink · 📅 30 April 2026 · ⏱ 40 min read
✍️ Need help with this assignment? Get expert quotes in minutes — free to submit. ✍️ Get Writing Help FREE

Benson Muthuri

{
“@context”: “https://schema.org”,
“@type”: “Article”,
“headline”: “Harvey Norman Ratio Analysis Assignment — How to Write Q1, Q2, and Q3 Using the 2024 and 2025 Annual Reports”,
“description”: “A structured guide for finance students completing the Harvey Norman investment bank report assignment — covering the business summary, all eight financial ratios, benchmarking against industry players, and the investment recommendation report.”,
“author”: {“@type”: “Organization”, “name”: “Smart Academic Writing”},
“publisher”: {
“@type”: “Organization”,
“name”: “Smart Academic Writing”,
“logo”: {“@type”: “ImageObject”, “url”: “https://smartacademicwriting.com/wp-content/uploads/2024/08/cropped-cropped-cropped-Smart-Academic-Writing-e1732959224567.png”}
},
“datePublished”: “2026-04-29”,
“dateModified”: “2026-04-29”,
“mainEntityOfPage”: {“@type”: “WebPage”, “@id”: “https://smartacademicwriting.com/harvey-norman-ratio-analysis-assignment/”}
}

{
“@context”: “https://schema.org”,
“@type”: “FAQPage”,
“mainEntity”: [
{
“@type”: “Question”,
“name”: “Where do I find the financial data to calculate Harvey Norman’s ratios?”,
“acceptedAnswer”: {
“@type”: “Answer”,
“text”: “All data for Q2 comes from Harvey Norman Holdings’ 2024 and 2025 Annual Reports, which are publicly available at harveynormanholdings.com.au under Reports & Announcements. The income statement provides revenue, gross profit, EBIT, interest expense, and net profit. The balance sheet provides current assets, current liabilities, inventory, accounts receivable, total assets, total debt, and shareholders’ equity. Use the consolidated financial statements — not segment-level data — for all ratio calculations.”
}
},
{
“@type”: “Question”,
“name”: “How do I benchmark Harvey Norman’s ratios against industry players?”,
“acceptedAnswer”: {
“@type”: “Answer”,
“text”: “The most relevant Australian retail comparators for Harvey Norman are JB Hi-Fi (ASX: JBH) and Wesfarmers (ASX: WES, through its Kmart and Target divisions). For each ratio you calculate for HVN, find the equivalent ratio for at least one comparator using their most recent annual report or financial data from ASX-listed company databases. The comparison should identify whether HVN’s ratios are stronger, weaker, or in line with peers — and explain what that means for an investor.”
}
},
{
“@type”: “Question”,
“name”: “How do I structure Q3 — the investment recommendation report?”,
“acceptedAnswer”: {
“@type”: “Answer”,
“text”: “Q3 is a 1,000-word investment report. It should open with a brief overview of Harvey Norman’s business and financial context, then work through the ratio analysis findings systematically — profitability, then liquidity and financial risk, then financial stability. Each ratio should be described (what it measures), interpreted (what HVN’s number means), trended (is it improving or deteriorating across 2024 vs 2025?), and benchmarked (how does it compare to a peer?). The report should close with a clear buy, hold, or sell recommendation that is directly supported by the ratio evidence presented. A recommendation that is not connected back to specific ratios will not satisfy the assignment instruction to ‘back up your arguments with the ratio analysis performed above.'”
}
}
]
}

:root{
–navy:#003366;–navy-dark:#002244;–navy-light:#004080;
–amber:#e6881a;–amber-dark:#cb6f0f;–amber-pale:#fff3dc;–amber-light:#fff9f0;
–cream:#FDFBF6;–warm-gray:#F5F1E8;–border:#DEE2E6;
–text:#1a1a2e;–text-muted:#555566;–white:#ffffff;
–green:#1a7a4a;–green-light:#e8f7ef;
–red:#c0392b;–red-light:#fdecea;
–teal:#0d6e6e;–teal-light:#e0f4f4;
–purple:#6c3483;–purple-light:#f4ecf7;
–blue:#1a5276;–blue-light:#d6eaf8;
–orange:#d35400;–orange-light:#fdebd0;
–indigo:#283593;–indigo-light:#e8eaf6;
}
*,*::before,*::after{margin:0;padding:0;box-sizing:border-box;}
html{scroll-behavior:smooth;}
body{font-family:’Source Sans 3′,sans-serif;background:var(–cream);color:var(–text);line-height:1.8;font-size:17px;}
.hero{background:var(–navy-dark);position:relative;overflow:hidden;}
.hero::before{content:”;position:absolute;inset:0;background:
radial-gradient(ellipse 80% 60% at 70% 35%,rgba(230,136,26,.15) 0%,transparent 58%),
radial-gradient(ellipse 45% 75% at 5% 90%,rgba(13,110,110,.1) 0%,transparent 55%),
radial-gradient(ellipse 35% 55% at 95% 5%,rgba(108,52,131,.09) 0%,transparent 50%);}
.hero-inner{max-width:1200px;margin:0 auto;padding:4.5rem 2rem 3.5rem;display:grid;grid-template-columns:1fr 340px;gap:3rem;align-items:center;position:relative;z-index:1;}
.hero-badge{display:inline-flex;align-items:center;gap:.4rem;background:rgba(230,136,26,.18);border:1px solid rgba(230,136,26,.4);color:var(–amber);font-family:’Fira Mono’,monospace;font-size:.72rem;letter-spacing:.12em;text-transform:uppercase;padding:.35rem .9rem;border-radius:4px;margin-bottom:1.3rem;}
.hero h2{font-family:’Bitter’,serif;font-size:clamp(1.85rem,4vw,3rem);font-weight:900;color:var(–white);line-height:1.14;margin-bottom:1.25rem;}
.hero h2 em{color:var(–amber);font-style:normal;}
.hero-lead{color:rgba(255,255,255,.82);font-size:1.08rem;line-height:1.85;max-width:580px;margin-bottom:2rem;}
.hero-meta{display:flex;gap:1.5rem;flex-wrap:wrap;}
.hero-meta-item{display:flex;align-items:center;gap:.5rem;color:rgba(255,255,255,.6);font-size:.85rem;}
.hero-meta-item svg{width:16px;height:16px;fill:var(–amber);flex-shrink:0;}
.hero-card{background:rgba(255,255,255,.06);border:1px solid rgba(255,255,255,.12);border-radius:16px;padding:1.75rem;backdrop-filter:blur(8px);}
.hero-card h3{font-family:’Bitter’,serif;color:var(–amber);font-size:.8rem;text-transform:uppercase;letter-spacing:.1em;margin-bottom:1rem;}
.toc-list{list-style:none;counter-reset:toc;}
.toc-list li{counter-increment:toc;padding:.42rem 0;border-bottom:1px solid rgba(255,255,255,.07);display:flex;align-items:baseline;gap:.6rem;}
.toc-list li:last-child{border-bottom:none;}
.toc-list li::before{content:counter(toc,decimal-leading-zero);font-family:’Fira Mono’,monospace;font-size:.72rem;color:var(–amber);flex-shrink:0;}
.toc-list a{color:rgba(255,255,255,.75);text-decoration:none;font-size:.87rem;transition:color .2s;line-height:1.4;}
.toc-list a:hover{color:var(–amber);}
.amber-band{background:var(–amber);padding:1.1rem 2rem;}
.amber-band-inner{max-width:1200px;margin:0 auto;display:flex;align-items:center;justify-content:space-between;gap:1rem;flex-wrap:wrap;}
.amber-band p{color:white;font-weight:600;font-size:1rem;}
.amber-band a{background:white;color:var(–amber-dark);padding:.55rem 1.5rem;border-radius:50px;font-weight:700;text-decoration:none;font-size:.9rem;white-space:nowrap;transition:transform .2s,box-shadow .2s;flex-shrink:0;}
.amber-band a:hover{transform:translateY(-2px);box-shadow:0 4px 12px rgba(0,0,0,.2);}
.page-body{max-width:1200px;margin:0 auto;padding:3rem 2rem;display:grid;grid-template-columns:1fr 300px;gap:3rem;align-items:start;}
.main-content{min-width:0;}
.sidebar{position:sticky;top:2rem;}
.sidebar-block{background:white;border-radius:14px;padding:1.5rem;margin-bottom:1.5rem;border:1px solid var(–border);box-shadow:0 2px 12px rgba(0,51,102,.06);}
.sidebar-block h4{font-family:’Bitter’,serif;font-size:.95rem;color:var(–navy);margin-bottom:1rem;padding-bottom:.6rem;border-bottom:2px solid var(–amber);text-transform:uppercase;letter-spacing:.05em;}
.sidebar-link-list{list-style:none;}
.sidebar-link-list li{margin-bottom:.5rem;}
.sidebar-link-list a{color:var(–text-muted);text-decoration:none;font-size:.88rem;display:flex;align-items:center;gap:.4rem;transition:color .2s;}
.sidebar-link-list a::before{content:’→’;color:var(–amber);font-size:.8rem;}
.sidebar-link-list a:hover{color:var(–navy);}
.sidebar-cta{background:linear-gradient(135deg,var(–navy),var(–navy-light));border-radius:14px;padding:1.75rem 1.5rem;text-align:center;color:white;}
.sidebar-cta h4{font-family:’Bitter’,serif;font-size:1.1rem;margin-bottom:.75rem;color:white;border:none;padding:0;text-transform:none;letter-spacing:0;}
.sidebar-cta p{font-size:.88rem;opacity:.8;margin-bottom:1.25rem;line-height:1.6;}
.sidebar-cta a{display:block;background:var(–amber);color:white;padding:.7rem 1.2rem;border-radius:8px;font-weight:700;text-decoration:none;font-size:.9rem;transition:background .2s,transform .2s;}
.sidebar-cta a:hover{background:var(–amber-dark);transform:translateY(-2px);}
.tag{display:inline-block;background:var(–amber-pale);color:var(–amber-dark);border:1px solid rgba(230,136,26,.3);font-family:’Fira Mono’,monospace;font-size:.75rem;padding:.2rem .6rem;border-radius:4px;margin:.15rem;}
.section{margin-bottom:3.5rem;}
.section-label{display:inline-flex;align-items:center;gap:.5rem;font-family:’Fira Mono’,monospace;font-size:.72rem;text-transform:uppercase;letter-spacing:.12em;color:var(–amber);margin-bottom:.6rem;}
.section-label::before{content:”;display:block;width:24px;height:2px;background:var(–amber);}
h2.section-title{font-family:’Bitter’,serif;font-size:clamp(1.55rem,2.8vw,2rem);font-weight:700;color:var(–navy);line-height:1.25;margin-bottom:1.25rem;}
h3.sub-title{font-family:’Bitter’,serif;font-size:1.2rem;font-weight:700;color:var(–navy);margin:2rem 0 .75rem;}
p{margin-bottom:1.1rem;color:var(–text);}
strong{color:var(–navy);font-weight:600;}
a{color:var(–amber);text-decoration:none;}
a:hover{text-decoration:underline;}
.divider{border:none;height:2px;background:linear-gradient(to right,var(–amber),transparent);margin:2.5rem 0;border-radius:2px;}
.definition-card{background:linear-gradient(135deg,var(–navy) 0%,var(–navy-light) 100%);color:white;border-radius:16px;padding:2.25rem 2.5rem;margin-bottom:2.5rem;position:relative;overflow:hidden;}
.definition-card::after{content:’📊’;position:absolute;right:2rem;top:50%;transform:translateY(-50%);font-size:5rem;opacity:.08;}
.definition-card .def-label{font-family:’Fira Mono’,monospace;font-size:.72rem;text-transform:uppercase;letter-spacing:.12em;color:var(–amber);margin-bottom:.75rem;}
.definition-card p{color:rgba(255,255,255,.9);font-size:1.08rem;line-height:1.8;margin:0;}
.info-box{border-radius:12px;padding:1.5rem 1.75rem;margin:2rem 0;display:flex;gap:1rem;}
.info-box-icon{font-size:1.5rem;flex-shrink:0;margin-top:.1rem;}
.info-box-content h4{font-family:’Bitter’,serif;font-size:1rem;margin-bottom:.5rem;}
.info-box-content p{margin:0;font-size:.95rem;line-height:1.7;}
.info-box-content ul{padding-left:1.2rem;margin-top:.5rem;}
.info-box-content li{font-size:.93rem;margin-bottom:.35rem;}
.info-box.tip{background:var(–amber-light);border-left:4px solid var(–amber);}
.info-box.tip .info-box-content h4{color:var(–amber-dark);}
.info-box.note{background:var(–teal-light);border-left:4px solid var(–teal);}
.info-box.note .info-box-content h4{color:var(–teal);}
.info-box.warning{background:var(–red-light);border-left:4px solid var(–red);}
.info-box.warning .info-box-content h4{color:var(–red);}
.info-box.success{background:var(–green-light);border-left:4px solid var(–green);}
.info-box.success .info-box-content h4{color:var(–green);}
.info-box.purple{background:var(–purple-light);border-left:4px solid var(–purple);}
.info-box.purple .info-box-content h4{color:var(–purple);}
.framework-band{background:linear-gradient(135deg,var(–navy-dark) 0%,#1a3a5c 100%);border-radius:16px;overflow:hidden;margin:2rem 0;}
.framework-band-header{padding:1.5rem 2rem 1rem;}
.framework-band-header h3{font-family:’Bitter’,serif;color:var(–amber);font-size:1.2rem;margin:0 0 .4rem;}
.framework-band-header p{color:rgba(255,255,255,.75);font-size:.9rem;margin:0;}
.fw-units{display:grid;grid-template-columns:repeat(3,1fr);padding:0 1rem 1.5rem;gap:.75rem;}
.fw-unit{background:rgba(255,255,255,.07);border:1px solid rgba(255,255,255,.12);border-radius:10px;padding:.9rem .85rem;}
.fw-unit-lbl{font-family:’Fira Mono’,monospace;font-size:.65rem;color:var(–amber);text-transform:uppercase;letter-spacing:.1em;display:block;margin-bottom:.3rem;}
.fw-unit h4{font-family:’Bitter’,serif;font-size:.85rem;color:white;margin:0 0 .4rem;line-height:1.3;}
.fw-unit ul{list-style:none;padding:0;}
.fw-unit li{font-size:.78rem;color:rgba(255,255,255,.65);padding:.15rem 0 .15rem .85rem;position:relative;line-height:1.4;}
.fw-unit li::before{content:’·’;position:absolute;left:0;color:var(–amber);}
.mosaic-row{display:grid;gap:1rem;margin-bottom:1rem;}
.mosaic-row.cols-3{grid-template-columns:repeat(3,1fr);}
.mosaic-row.cols-2{grid-template-columns:2fr 1fr;}
.mosaic-row.cols-2r{grid-template-columns:1fr 2fr;}
.mosaic-tile{border-radius:12px;padding:1.15rem 1.25rem;cursor:default;transition:transform .2s,box-shadow .2s;border:1px solid rgba(255,255,255,.15);}
.mosaic-tile:hover{transform:translateY(-3px);box-shadow:0 8px 24px rgba(0,0,0,.12);}
.mosaic-tile h4{font-family:’Bitter’,serif;font-size:.95rem;font-weight:700;margin:0 0 .3rem;}
.mosaic-tile p{font-size:.82rem;margin:0;line-height:1.5;opacity:.9;}
.mosaic-tile .tile-badge{font-family:’Fira Mono’,monospace;font-size:.65rem;text-transform:uppercase;letter-spacing:.08em;padding:.15rem .5rem;border-radius:3px;margin-bottom:.4rem;display:inline-block;}
.tile-purple{background:linear-gradient(135deg,#7d3c98,#6c3483);color:white;}
.tile-purple .tile-badge{background:rgba(255,255,255,.2);color:white;}
.tile-teal{background:linear-gradient(135deg,#0d6e6e,#0a5858);color:white;}
.tile-teal .tile-badge{background:rgba(255,255,255,.2);color:white;}
.tile-blue{background:linear-gradient(135deg,#1a5276,#154360);color:white;}
.tile-blue .tile-badge{background:rgba(255,255,255,.2);color:white;}
.tile-green{background:linear-gradient(135deg,#1a7a4a,#15633c);color:white;}
.tile-green .tile-badge{background:rgba(255,255,255,.2);color:white;}
.tile-amber{background:linear-gradient(135deg,#e6881a,#cb6f0f);color:white;}
.tile-amber .tile-badge{background:rgba(255,255,255,.2);color:white;}
.tile-red{background:linear-gradient(135deg,#c0392b,#a93226);color:white;}
.tile-red .tile-badge{background:rgba(255,255,255,.2);color:white;}
.tile-navy{background:linear-gradient(135deg,#003366,#002244);color:white;}
.tile-navy .tile-badge{background:rgba(255,255,255,.2);color:white;}
.tile-indigo{background:linear-gradient(135deg,#283593,#1a237e);color:white;}
.tile-indigo .tile-badge{background:rgba(255,255,255,.2);color:white;}
.tile-orange{background:linear-gradient(135deg,#d35400,#ba4a00);color:white;}
.tile-orange .tile-badge{background:rgba(255,255,255,.2);color:white;}
.int-table-wrap{overflow-x:auto;margin:1.5rem 0;border-radius:12px;border:1px solid var(–border);}
.int-table{width:100%;border-collapse:collapse;font-size:.92rem;background:white;}
.int-table thead tr{background:var(–navy);}
.int-table th{color:white;text-align:left;padding:.85rem 1rem;font-family:’Fira Mono’,monospace;font-size:.78rem;text-transform:uppercase;letter-spacing:.07em;font-weight:500;}
.int-table td{padding:.8rem 1rem;border-bottom:1px solid var(–border);vertical-align:top;line-height:1.55;}
.int-table tr:last-child td{border-bottom:none;}
.int-table tr:nth-child(even) td{background:var(–cream);}
.int-table tr:hover td{background:var(–amber-light);}
.int-table td:first-child{font-weight:600;color:var(–navy);}
.pull-quote{margin:2.5rem 0;padding:1.75rem 2rem;background:var(–warm-gray);border-radius:0 16px 16px 0;border-left:6px solid var(–amber);position:relative;}
.pull-quote::before{content:'”‘;position:absolute;top:-.5rem;left:1.5rem;font-family:’Bitter’,serif;font-size:5rem;color:var(–amber);opacity:.25;line-height:1;}
.pull-quote p{font-family:’Bitter’,serif;font-size:1.15rem;font-style:italic;color:var(–navy);line-height:1.7;margin:0 0 .5rem;}
.pull-quote cite{font-size:.85rem;color:var(–text-muted);font-style:normal;font-weight:600;}
.two-col{display:grid;grid-template-columns:1fr 1fr;gap:1.25rem;margin:1.5rem 0;}
.col-card{background:white;border:1px solid var(–border);border-radius:12px;padding:1.5rem;}
.col-card h4{font-family:’Bitter’,serif;font-size:1rem;color:var(–navy);margin-bottom:.75rem;padding-bottom:.5rem;border-bottom:2px solid var(–amber);}
.col-card ul{list-style:none;padding:0;}
.col-card li{font-size:.9rem;color:var(–text-muted);padding:.35rem 0;border-bottom:1px solid var(–border);line-height:1.5;}
.col-card li:last-child{border-bottom:none;}
.col-card li::before{content:’• ‘;color:var(–amber);font-weight:700;}
.checklist{list-style:none;padding:0;}
.checklist li{padding:.4rem 0 .4rem 1.75rem;position:relative;font-size:.96rem;border-bottom:1px solid var(–border);}
.checklist li:last-child{border-bottom:none;}
.checklist li::before{content:’✓’;position:absolute;left:0;color:var(–green);font-weight:700;}
.cta-banner{background:linear-gradient(135deg,var(–amber) 0%,var(–amber-dark) 100%);border-radius:20px;padding:3rem 2.5rem;text-align:center;margin:3rem 0;position:relative;overflow:hidden;}
.cta-banner::before{content:”;position:absolute;inset:0;background:radial-gradient(ellipse at 80% 20%,rgba(255,255,255,.12),transparent 60%);}
.cta-banner h2{font-family:’Bitter’,serif;font-size:1.9rem;color:white;margin-bottom:.75rem;position:relative;}
.cta-banner p{color:rgba(255,255,255,.9);font-size:1.05rem;margin-bottom:1.75rem;max-width:580px;margin-left:auto;margin-right:auto;position:relative;}
.cta-banner a{display:inline-block;background:white;color:var(–amber-dark);padding:.9rem 2.5rem;border-radius:50px;font-weight:700;text-decoration:none;font-size:1rem;position:relative;transition:transform .2s,box-shadow .2s;box-shadow:0 4px 16px rgba(0,0,0,.15);}
.cta-banner a:hover{transform:translateY(-3px);box-shadow:0 8px 24px rgba(0,0,0,.25);}
.faq-list{margin:1.5rem 0;}
.faq-item{background:white;border:1px solid var(–border);border-radius:12px;margin-bottom:1rem;overflow:hidden;}
.faq-q{font-family:’Bitter’,serif;font-size:1.02rem;color:var(–navy);padding:1.2rem 1.5rem;cursor:pointer;display:flex;justify-content:space-between;align-items:center;user-select:none;font-weight:600;}
.faq-q::after{content:’+’;color:var(–amber);font-size:1.2rem;flex-shrink:0;margin-left:1rem;}
.faq-item.open .faq-q::after{content:’-’;}
.faq-a{display:none;padding:0 1.5rem 1.3rem;font-size:.96rem;color:var(–text-muted);line-height:1.75;border-top:1px solid var(–border);padding-top:1rem;}
.faq-item.open .faq-a{display:block;}
.compare-pair{display:grid;grid-template-columns:1fr 1fr;gap:1rem;margin:1.75rem 0;}
.compare-card{background:white;border:1px solid var(–border);border-radius:12px;overflow:hidden;}
.compare-card-head{padding:.75rem 1.25rem;font-family:’Bitter’,serif;font-size:.9rem;font-weight:700;display:flex;align-items:center;gap:.5rem;}
.compare-card-head.good{background:var(–green-light);color:var(–green);}
.compare-card-head.bad{background:var(–red-light);color:var(–red);}
.compare-card-body{padding:1rem 1.25rem;font-size:.9rem;color:var(–text-muted);font-style:italic;line-height:1.7;}
.formula-block{background:var(–navy-dark);border-radius:10px;padding:1rem 1.5rem;margin:.75rem 0;font-family:’Fira Mono’,monospace;font-size:.92rem;color:var(–amber);letter-spacing:.03em;border-left:4px solid var(–amber);}
@media(max-width:900px){
.hero-inner{grid-template-columns:1fr;}
.hero-card{display:none;}
.page-body{grid-template-columns:1fr;}
.sidebar{display:none;}
.fw-units{grid-template-columns:repeat(2,1fr);}
.mosaic-row.cols-3{grid-template-columns:repeat(2,1fr);}
.mosaic-row.cols-2,.mosaic-row.cols-2r{grid-template-columns:1fr;}
.compare-pair{grid-template-columns:1fr;}
.two-col{grid-template-columns:1fr;}
}
@media(max-width:640px){
.fw-units{grid-template-columns:1fr;}
.mosaic-row.cols-3{grid-template-columns:1fr;}
}
@keyframes fadeUp{from{opacity:0;transform:translateY(16px);}to{opacity:1;transform:translateY(0);}}
.section{animation:fadeUp .5s ease both;}

Australian University — Finance Assessment 3

Harvey Norman Ratio Analysis Assignment —
How to Write Q1, Q2 (All Eight Ratios), and Q3

Your assessment asks you to summarise Harvey Norman’s business, calculate eight specific financial ratios using the 2024 and 2025 annual reports, benchmark those ratios against industry peers, and write a 1,000-word investment recommendation backed by ratio evidence. That is three distinct deliverables with different analytical requirements. This guide maps exactly what each question is asking — and how to approach each one with the precision the rubric rewards.

18 min read

~4,200 Words

Updated April 29, 2026

Need expert help with your Harvey Norman financial analysis or ratio assignment?

Get Expert Help →

What This Assessment Is Actually Testing — and Why Students Lose Marks

The Three-Part Deliverable

This assessment has three components submitted as two files. First, a Word document containing Q1 (200-word business summary with latest news) and Q3 (1,000-word ratio analysis report with investment recommendation). Second, an Excel spreadsheet containing Q2 (all eight financial ratios calculated from Harvey Norman’s 2024 and 2025 annual reports). The assessment instruction is explicit: describe each ratio and its purpose, understand the trend across years, benchmark against industry players, and back up your recommendation with ratio evidence. Students who calculate the ratios but do not interpret them, or who make a recommendation without connecting it to ratio findings, are not meeting the assessment’s analytical standard — and the rubric will reflect that.

The distinction the rubric is drawing is between calculation and analysis. Calculating a current ratio of 1.43 is one step. Explaining that a current ratio above 1.0 signals Harvey Norman can meet its short-term obligations, noting whether that number improved or declined from 2024 to 2025, and comparing it against JB Hi-Fi’s equivalent ratio to judge whether HVN is more or less liquid than its closest Australian retail peer — that is analysis. The marks sit with the analysis, not the arithmetic.

The Excel file is not a worksheet you hand in as a separate afterthought. A professionally formatted spreadsheet — clear labels, consistent number formatting, ratio categories grouped by type, colour-coded headers, and a brief description of each ratio’s purpose — is explicitly noted in the assessment brief as important. In a real investment banking context, an analyst’s spreadsheet is a client-facing document. Treat it that way.

Where to Get the Annual Reports

Harvey Norman Holdings Limited publishes its annual reports directly at harveynormanholdings.com.au under the Reports & Announcements section. Both the 2024 and 2025 annual reports are available as PDFs. The consolidated financial statements — specifically the Consolidated Statement of Comprehensive Income, Consolidated Statement of Financial Position, and Consolidated Statement of Cash Flows — are the source documents for all your ratio inputs. Download both before doing any calculations. Harvey Norman’s financial year ends 30 June, so FY2025 covers the period 1 July 2024 to 30 June 2025, and FY2024 covers 1 July 2023 to 30 June 2024.


Q1 — How to Write the Business Summary with Latest News (200 Words)

Q1 is not a historical essay about Harvey Norman’s founding. It is a concise professional briefing note of the kind an investment banking analyst would prepare for a manager before a meeting. At 200 words, every sentence must do work. The structure should cover what the business is and how it makes money, its scale and geographic footprint, and one or two pieces of recent news that are relevant to an investment decision.

Business Model

What Harvey Norman Does and How It Earns Revenue

Harvey Norman Holdings (ASX: HVN) operates a franchise-based retail model. It earns revenue from property rental income (leasing store space to franchisees), company-operated retail (in international markets), and franchisee support. This hybrid model — part property company, part retailer — is a key feature that distinguishes HVN from pure-play Australian retailers and directly affects how you interpret its financial ratios. A Q1 paragraph that describes HVN only as a “furniture and electronics retailer” without mentioning the franchise and property dimensions is missing the most analytically significant feature of the business.

Scale and Footprint

Geographic Presence and Store Network

Harvey Norman operates across Australia, New Zealand, Ireland, Northern Ireland, Singapore, Malaysia, Slovenia, Croatia, and other international markets. As of the 2025 reporting period, Australia remains the dominant revenue contributor, but international operations — particularly property-backed stores in Europe and Asia-Pacific — represent a meaningful portion of the balance sheet. Including the geographic breadth signals to a reader that HVN carries exposure to multiple currency and economic environments, which is a risk factor relevant to your investment recommendation in Q3.

Latest News

Recent Developments Relevant to an Investor

For Q1, “latest news” means recent corporate developments, earnings updates, or market conditions that an investor would want to know before making a capital allocation decision. Check HVN’s ASX announcements page for anything filed since the most recent annual report — half-year results, CEO statements, dividend announcements, major acquisitions, or property divestments. A 200-word business brief that includes a specific recent announcement is demonstrably more useful to a manager than one that only restates what the annual report cover page says. Use the ASX announcements portal at asx.com.au or the HVN investor page directly.

The 200-Word Constraint Is a Test of Precision, Not a Target to Pad

Two hundred words is tight. A paragraph on the business model (approximately 80 words), a sentence or two on geographic scale and revenue breakdown (approximately 50 words), and a focused note on the most relevant recent news item (approximately 70 words) will fill the limit precisely. Do not spend words on history that predates the current investment context. The manager reading your brief already knows Harvey Norman is a long-established Australian brand. She wants the current state of play and anything new that changes the investment thesis.


Q2 — The Eight Financial Ratios: What Each Measures and Where to Find the Data

Your assessment requires eight ratios across three categories. Each category tests a different dimension of financial health. Profitability ratios test how efficiently HVN converts revenue into profit. Liquidity and financial risk ratios test whether HVN can meet its obligations and how efficiently it manages working capital. Financial stability ratios test how HVN is financed and whether its debt burden is sustainable. Understanding what category each ratio belongs to — and what question it answers for an investor — is prerequisite to writing the Q3 report coherently.

All Eight Required Ratios — Category, Purpose, Formula Inputs, and Annual Report Location

Every formula input maps to a specific line item in Harvey Norman’s consolidated financial statements. Identifying the right line items before calculating prevents the most common source of error in this assessment.

Profitability — Ratio 1

Profit Margin (Net Profit Margin)

  • Measures how many cents of net profit HVN keeps per dollar of revenue
  • Formula: Net Profit After Tax ÷ Total Revenue × 100
  • Income statement: Net profit attributable to shareholders of Harvey Norman Holdings; Total revenue or total income from operations
  • A declining margin signals cost pressure or revenue mix shift; rising margin signals operational efficiency gains
Profitability — Ratio 2

Return on Assets (ROA)

  • Measures how effectively management deploys the total asset base to generate profit
  • Formula: Net Profit After Tax ÷ Average Total Assets × 100
  • Average total assets = (Opening total assets + Closing total assets) ÷ 2; use FY2023 closing for FY2024’s opening
  • Low ROA relative to peers indicates the asset base (particularly HVN’s large property portfolio) is not being fully optimised
Profitability — Ratio 3

Return on Equity (ROE)

  • Measures the return generated on shareholders’ capital — the most watched profitability metric by equity investors
  • Formula: Net Profit After Tax ÷ Average Shareholders’ Equity × 100
  • Balance sheet: Total equity attributable to equity holders of Harvey Norman Holdings (exclude non-controlling interests)
  • ROE is the key metric for the Q3 recommendation — an ROE consistently below the cost of equity suggests the investment is destroying value
Liquidity — Ratio 4

Current Ratio

  • Tests whether HVN can cover its short-term liabilities with its short-term assets
  • Formula: Current Assets ÷ Current Liabilities
  • Balance sheet: Total current assets and total current liabilities from the Consolidated Statement of Financial Position
  • A ratio below 1.0 signals potential liquidity risk; above 2.0 may indicate inefficient use of working capital
Liquidity — Ratio 5 & 6

Inventory Turnover Ratio and Days

  • Measures how many times HVN sells and replaces its inventory in a year, and the average days goods sit unsold
  • Turnover formula: Cost of Goods Sold ÷ Average Inventory
  • Days formula: 365 ÷ Inventory Turnover Ratio
  • Average inventory = (Opening + Closing inventory) ÷ 2; COGS is on the income statement; inventory is on the balance sheet under current assets
  • Higher turnover (fewer days) generally means faster cash conversion — critical for a retailer
Liquidity — Ratio 7 & 8 (counted as one)

Accounts Receivable Turnover Ratio and Days

  • Measures how efficiently HVN collects payments from customers and franchisees
  • Turnover formula: Net Credit Sales (or Total Revenue) ÷ Average Accounts Receivable
  • Days formula: 365 ÷ Accounts Receivable Turnover
  • For HVN, accounts receivable on the balance sheet includes franchisee receivables — a significant and distinctive line item given the franchise model
  • Rising receivable days may signal collection issues with franchisees, which is a credit risk flag for investors
Financial Stability — Ratio 9

Debt to Equity Ratio

  • Measures how much of HVN’s financing comes from debt relative to equity — tests capital structure risk
  • Formula: Total Debt (borrowings) ÷ Total Shareholders’ Equity
  • Use total borrowings (current and non-current) from the balance sheet; use equity attributable to HVN shareholders
  • A rising D/E ratio signals increasing financial leverage; in a rising interest rate environment this amplifies risk
Financial Stability — Ratio 10

Interest Coverage Ratio

  • Tests whether HVN generates enough operating profit to comfortably service its interest obligations
  • Formula: EBIT ÷ Interest Expense
  • EBIT (earnings before interest and tax) is on the income statement; interest expense is a separate line item, often in the notes
  • A ratio below 2.0x is considered a warning sign in most industry contexts; above 5.0x suggests comfortable debt serviceability

Use Averages Correctly — This Is One of the Most Common Calculation Errors

ROA, ROE, inventory turnover, and accounts receivable turnover all require average balance sheet figures in the denominator — not the closing balance for the single year you are calculating. Average = (prior year closing balance + current year closing balance) ÷ 2. For FY2024 ratios, the opening balance is the FY2023 closing figure, which you find in the comparative column of the FY2024 annual report. For FY2025 ratios, the opening balance is the FY2024 closing figure. Students who use only the current year’s closing balance instead of the average will calculate systematically different ROA and ROE figures — and those errors will carry into Q3 if not caught.


How to Calculate Each Ratio Step by Step — and Structure the Excel File

The Excel spreadsheet is a professional deliverable. Before entering a single formula, design the layout. A professional ratio analysis spreadsheet groups ratios by category, labels each ratio clearly, shows the formula, shows the raw inputs (with source references), and shows the calculated output for both FY2024 and FY2025 side by side so the trend is immediately visible. The note in the assessment brief that a “professionally formatted” submission earns better marks is not a soft suggestion — it reflects how ratio analysis is actually done in industry.

A Recommended Excel Layout Structure

Column Content Notes
A — Ratio Name Full name of the ratio (e.g., “Net Profit Margin”) Group rows by category with a shaded header row: Profitability, Liquidity & Financial Risk, Financial Stability
B — Purpose One sentence describing what this ratio measures and why it matters to an investor This satisfies the rubric’s requirement to “describe each ratio and its purpose” — do this in the Excel, not just in the Word doc
C — Formula The algebraic formula written out (e.g., “Net Profit ÷ Revenue × 100”) Not the Excel cell reference — write the actual formula in plain language so anyone reading the spreadsheet understands the calculation
D & E — FY2024 Inputs Numerator value and denominator value for FY2024, with source references (e.g., “Income Statement, Line: Net Profit”) Sourcing each input prevents errors and allows the marker to verify your figures against the annual report
F — FY2024 Result The calculated ratio for FY2024, formatted appropriately (% for profitability ratios; x for coverage ratios; days for turnover days) Use Excel number formatting — do not leave raw decimal output
G & H — FY2025 Inputs Numerator and denominator for FY2025, sourced as above Showing inputs for both years separately prevents the marker from having to reverse-engineer your calculations
I — FY2025 Result The calculated ratio for FY2025 Place FY2024 and FY2025 results in adjacent columns so the trend is visible at a glance
J — Trend Brief directional note: “Improved,” “Declined,” or “Stable” with a conditional format (green for improved, red for declined) This is the analytical layer that separates a calculation sheet from a professional analysis document
K — Industry Benchmark Comparable ratio for the selected peer (e.g., JB Hi-Fi FY2025) with source note Having the peer benchmark in the spreadsheet, not just mentioned in the Word doc, demonstrates thoroughness

Key Formula Applications for Harvey Norman

The formulas themselves are standard — what requires care is identifying the correct Harvey Norman line items. HVN’s income statement structure and balance sheet include some items that are specific to its franchise model and are not standard in a simple retailer’s accounts. These are the most important data points to locate correctly:

Income Statement — Key Lines

  • Revenue from contracts with customers — use this as “Total Revenue” for profit margin and receivables turnover
  • Cost of sales — use this as COGS for inventory turnover
  • Profit before income tax expense — use this plus interest expense to derive EBIT, or locate EBIT separately in the notes
  • Finance costs — this is interest expense for the interest coverage ratio
  • Profit for the year attributable to owners of the parent — use this as Net Profit for all profitability ratios

Balance Sheet — Key Lines

  • Total current assets and total current liabilities — current ratio numerator and denominator
  • Inventories (within current assets) — inventory turnover denominator
  • Trade and other receivables (within current assets) — receivables turnover denominator; note HVN also has non-current receivables from franchisees, so clarify which class you are using
  • Borrowings (current + non-current) — total debt for debt-to-equity ratio
  • Total equity attributable to equity holders of Harvey Norman Holdings — equity for ROE and debt-to-equity
  • Total assets — ROA denominator (remember to average across FY2024 and FY2025)

A ratio is only as reliable as the line items feeding it. Spend thirty minutes mapping each formula to the correct annual report line before entering a single Excel formula — that time investment prevents errors that would otherwise run through every calculation in the spreadsheet.

— The precision standard the assessment is measuring


Benchmarking Against Industry Players — Why It Matters and How to Do It

The assessment note is explicit: “Research should include some benchmarking against industry players.” A ratio in isolation tells you a number. A ratio compared against a peer tells you whether that number is strong, weak, or in line with what comparable businesses achieve in the same operating environment. The benchmarking requirement is not optional — it is the layer of analysis that distinguishes a financial analyst from a spreadsheet operator.

Primary Comparator

JB Hi-Fi (ASX: JBH)

JB Hi-Fi is the most direct Australian comparator for Harvey Norman’s electronics and appliances categories. It is ASX-listed, reports annually on a June financial year, and publishes ratios that are widely discussed in Australian financial media. For liquidity and profitability comparisons specifically, JBH is the most relevant benchmark. Its annual reports are available at jbhifi.com.au and its ASX filings are publicly accessible.

Secondary Comparator

Wesfarmers (ASX: WES) — Kmart / Target

Wesfarmers is a broader conglomerate but its discretionary retail divisions (Kmart and Target) compete with Harvey Norman on furniture, homewares, and appliance categories. WES is less of a pure peer than JBH, but useful for any benchmarking on inventory management efficiency, which is a major operational challenge across the Australian discretionary retail sector.

Industry Context

Australian Retail Sector Benchmarks

The Australian Bureau of Statistics and IBISWorld publish sector-level data on Australian retail performance, including average gross margins, inventory turnover rates, and return on assets for the retail trade sector. If you have access to IBISWorld through your university library, sector-level benchmarks add a layer of context beyond individual peer comparisons and can strengthen the analytical depth of your Q3 report significantly.

When presenting your benchmarking in Q3, the structure for each ratio should follow a consistent pattern: state HVN’s ratio, state the comparator’s ratio, state whether HVN is stronger or weaker, and briefly explain what that gap means for the investment case. “Harvey Norman’s current ratio of [X] compares to JB Hi-Fi’s [Y], suggesting HVN carries [more/less/similar] short-term liquidity risk. This is [positive/negative/neutral] from an investor’s perspective because…” That three-sentence structure, applied consistently, is what the rubric phrase “understand the trend” is pointing toward.

What “Understanding the Trend” Actually Means

Trend analysis in this context means comparing FY2024 and FY2025 values for each ratio and drawing a directional conclusion. Is the profit margin expanding or contracting? Is the current ratio improving or deteriorating? Is inventory being converted to cash faster or slower? The trend is the time dimension of the analysis — without it, you have a snapshot but not a trajectory. An investment recommendation built on trajectory evidence (ratios improving or deteriorating over two years) is analytically stronger than one built on a single year’s ratio values alone. Benchmarking adds the competitive dimension. Together, trend plus benchmark gives you a genuinely defensible recommendation.


Q3 — How to Write the Investment Recommendation Report (1,000 Words)

Q3 is the analytical centrepiece of the assessment. At 1,000 words it is long enough to develop a structured argument, but short enough that every paragraph must earn its place. The structure should mirror the ratio categories: an opening that frames the analysis, a profitability section, a liquidity section, a financial stability section, a benchmarking note, and a conclusion that delivers a clear buy, hold, or sell recommendation backed by ratio evidence. A report that describes the ratios without making a recommendation, or that makes a recommendation without citing specific ratios, fails the core brief on both ends.

A Reliable Structure for the Q3 Report

Section Content Approx. Length What the Rubric Is Looking For
Introduction Brief framing: who you are (investment bank analyst), what company you are analysing, what the report covers, and what its purpose is. One sentence on Harvey Norman’s business model and market position to orient the reader. Do not repeat Q1 — this is a forward-facing framing paragraph, not a business summary. 80–100 words Professional tone; clear statement of analytical purpose; no padding
Profitability Analysis State and interpret all three profitability ratios (profit margin, ROA, ROE) with FY2024 and FY2025 figures. Identify the trend direction for each. Draw a conclusion about whether HVN’s profitability is improving or deteriorating overall. Compare at least one profitability ratio against the chosen peer. Close with a sentence on what the profitability picture means for an equity investor. 250–280 words All three ratios named with actual calculated figures; trend direction stated; peer comparison included; analytical conclusion drawn — not just description
Liquidity and Financial Risk Analysis State and interpret the current ratio, inventory turnover (ratio and days), and accounts receivable turnover (ratio and days). For each: state the number, explain what it means, identify the trend, and note any concern or strength. The franchise model context is relevant here — HVN’s receivables include franchisee balances that behave differently from typical customer receivables. 280–300 words All five liquidity figures presented; trend analysis applied; Harvey Norman-specific interpretation that goes beyond textbook definition; at least one benchmarking comparison
Financial Stability Analysis State and interpret debt-to-equity and interest coverage ratios. Discuss what HVN’s leverage level implies for risk in the current Australian interest rate environment. A rising D/E ratio with declining interest coverage is a red flag; stable or improving coverage alongside manageable leverage is a positive signal. 150–180 words Both ratios with figures; interest rate context acknowledged; directional conclusion about financial risk level
Investment Recommendation A clear, direct recommendation — buy, hold, or sell — with the rationale drawn explicitly from the ratio findings. The recommendation should reference at least three specific ratio outcomes from the preceding analysis. It should also acknowledge the key risk or uncertainty that could change the recommendation (e.g., a significant deterioration in franchisee receivable collections, or further interest rate increases that pressure coverage ratios). 150–180 words Explicit buy/hold/sell statement; at least three ratio references supporting the recommendation; risk acknowledgement; no vague or hedged conclusion that refuses to take a position

The Recommendation Must Take a Position — Hedging Costs Marks

Students often conclude Q3 with a sentence like “Overall, Harvey Norman has both strengths and weaknesses, and investors should consider their individual risk tolerance before making a decision.” That is not a recommendation — it is a non-answer. The assessment brief says to recommend whether to invest in Harvey Norman shares or not. Your manager at the investment bank has asked you for a view. Give one. If the ratios support a positive case, argue buy. If they reveal deteriorating profitability and rising leverage, argue sell or hold. A well-argued recommendation that is wrong is analytically superior to a non-committal answer that is technically unfalsifiable. Take the position the evidence supports, and be explicit about why.

Pre-Submission Checklist for This Assessment

  • Q1 Word doc section: 200 words, covers business model, geographic scale, and at least one specific recent news item
  • Q2 Excel: all eight ratios calculated with correct formulas; both FY2024 and FY2025 values shown; inputs labelled with source references
  • Q2 Excel: average balance sheet figures used (not single-year closing values) for ROA, ROE, inventory turnover, and receivables turnover
  • Q2 Excel: ratios grouped by category (Profitability / Liquidity / Financial Stability) with clear formatting and headers
  • Q2 Excel: at least one industry peer benchmark included per ratio category
  • Q3 Word doc section: approximately 1,000 words; all ratio categories covered with figures cited
  • Q3 Word doc: trend analysis for each ratio (FY2024 vs FY2025 direction)
  • Q3 Word doc: benchmarking against at least one named industry peer per ratio category
  • Q3 Word doc: explicit buy, hold, or sell recommendation with at least three ratio references supporting it
  • Q3 Word doc: a risk or qualification statement acknowledging what could change the recommendation
  • Both deliverables submitted via Turnitin — Word document in Part 1, Excel in Part 2
  • Word document formatted professionally: consistent font, headings, and spacing; APA or Harvard referencing if sources are cited


Strong vs. Weak Responses — What the Difference Looks Like in Q3

✓ Strong Ratio Analysis Paragraph
“Harvey Norman’s net profit margin improved from [X]% in FY2024 to [Y]% in FY2025, indicating the company generated more profit per dollar of revenue in the most recent year. This improvement reflects a combination of [specific factor from annual report — e.g., cost of doing business reductions in the Australian franchise segment and improved trading conditions in international markets]. Compared to JB Hi-Fi’s net profit margin of [Z]% for the same period, Harvey Norman’s margin is [higher/lower], which is [noteworthy/expected] given HVN’s property income component, which typically carries higher margins than pure retail sales. The upward trend in profitability is a positive signal for equity investors, though margin sustainability depends on continued performance in the franchise support segment, which contributed [amount] to group profit in FY2025.” — This paragraph names the ratio, states both years’ values, identifies the trend direction, provides a company-specific explanation for the trend, benchmarks against a named peer, and closes with a forward-looking investor-relevant statement.

✗ Weak Ratio Analysis Paragraph
“The net profit margin shows how much profit the company makes from its revenue. Harvey Norman’s net profit margin is [X]%. This is an important ratio because it tells us if the company is making a profit. A higher net profit margin is generally better for a company. Harvey Norman’s profit margin shows the company is doing well overall.” — This paragraph defines the ratio correctly but that is all it does. It provides only one year’s figure (no trend), offers no company-specific explanation for the result, does not compare to any peer, and closes with a generic assertion (“doing well overall”) that is not supported by any evidence. It cannot earn more than basic marks on any rubric criterion that assesses analysis, trend identification, or benchmarking.

The same contrast applies across every ratio in Q3. Strong paragraphs name the specific figures, move immediately from the number to its meaning, identify whether the trend is improving or deteriorating, and draw an investor-relevant conclusion. Weak paragraphs define the ratio, state one number, and conclude with a generic statement. The definition adds no value because the reader of an investment banking report already knows what a current ratio measures. The value sits entirely in the interpretation — and interpretation is what this assessment is grading.


The Most Common Errors on This Assessment — and How to Avoid Them

# The Error Why It Costs Marks The Fix
1 Using single-year balance sheet values instead of averages for ROA, ROE, and turnover ratios ROA and ROE are measured against the average asset or equity base — using only the year-end figure produces a ratio that misrepresents how efficiently the business deployed resources across the whole year. Turnover ratios have the same requirement. This is a calculation methodology error, not a rounding error — it will produce meaningfully different numbers that may not match any published ratio for HVN. For every ratio that uses a balance sheet denominator, calculate: (prior year closing balance + current year closing balance) ÷ 2. The prior year closing balance is in the comparative column of the current year’s annual report. For FY2024 ratios, the FY2023 closing balance is in the comparative column of the FY2024 annual report. Build this averaging step into your Excel formula from the start.
2 Calculating ratios for only one year instead of both FY2024 and FY2025 The assessment explicitly requires you to read and use both the 2024 and 2025 annual reports. A submission that calculates ratios for FY2025 only cannot demonstrate trend analysis — and the rubric requires students to identify whether financials are improving or not. Single-year calculations also prevent meaningful benchmarking over time. Structure your Excel from the beginning with columns for both years. Calculate all ratios for FY2024 first, then duplicate the structure for FY2025, then add a trend column. This architecture ensures both years are present and forces you to compare them explicitly.
3 Writing Q3 as a description of ratios rather than an analysis Describing what each ratio means and stating HVN’s value is the minimum standard — it earns pass marks but not credit for analysis. The distinction the rubric is drawing is between reporting (these are the numbers) and analysing (this is what the numbers mean for an investor, how they compare to peers, and what they imply about the investment decision). A 1,000-word Q3 that devotes 600 words to definitions and 400 words to actual interpretation has its priorities inverted. After calculating every ratio, write a single sentence that starts: “This means…” Force yourself to interpret before you describe. Then write the benchmarking comparison. Then write the trend direction. Only after those three moves describe what the ratio measures. That ordering keeps analysis at the centre and prevents a report that front-loads definitions and runs out of space for conclusions.
4 Making a recommendation without citing specific ratios The assessment brief is direct: “when you make the recommendation you must back up your arguments with the ratio analysis performed above.” A recommendation paragraph that does not name specific ratios — or that names them generically (“Harvey Norman’s profitability ratios are acceptable”) without quoting the actual figures — has not met this requirement. The marker cannot verify the link between the recommendation and the analysis if no ratios are cited. Write the recommendation paragraph last, after you have completed the analysis sections. Then go back through your recommendation and check that each statement supporting the buy/hold/sell position references at least one specific ratio with its calculated value. “HVN’s interest coverage ratio of [X]x in FY2025, down from [Y]x in FY2024, combined with a debt-to-equity ratio of [Z], suggests…” is the level of specificity the rubric requires.
5 No benchmarking or vague benchmarking without named peers or figures Stating “Harvey Norman’s current ratio is in line with industry standards” without naming the industry standard, citing a source, or specifying a peer is not benchmarking — it is an assertion. The rubric requirement for “benchmarking against industry players” is satisfied by named peers with named figures from a verifiable source. Assertions without evidence earn no benchmarking marks. Before writing Q3, look up JB Hi-Fi’s most recent annual report or use a financial data service (your university library likely provides access to Bloomberg, Morningstar, or similar) to obtain its current ratio, net profit margin, and debt-to-equity ratio. Note the source. Use those figures in your analysis. One well-sourced peer comparison per ratio category satisfies the benchmarking requirement and demonstrates research discipline that markers reward.
6 Poorly formatted Excel with no labels, no ratio descriptions, or inconsistent number formatting The assessment brief notes explicitly that “presentation of a professionally looking report and excel is very important in industry.” An Excel file that shows raw numbers without labels, formulas without explanations, or inconsistent decimal places is not a professional deliverable. In an investment banking context, a poorly formatted model would not be sent to a client — and this assessment is simulating that professional standard. After completing all calculations, spend thirty minutes on formatting. Add category header rows with background colour. Ensure all percentages are formatted as percentages (not 0.0743), all ratios as two decimal places, all days figures as whole numbers. Add a short description of each ratio’s purpose in an adjacent column. Add borders and alignment. Print-preview the spreadsheet to check it would be readable as a PDF — because that is how the marker will view it after downloading from Turnitin.

Need Expert Help With Your Harvey Norman Finance Assignment?

Our team covers financial ratio analysis, investment report writing, and professionally formatted Excel spreadsheets for Australian university finance assessments.

Get Professional Help Now →

FAQs: Harvey Norman Ratio Analysis Assignment

Where do I find the financial data to calculate Harvey Norman’s ratios?
All data for Q2 comes from Harvey Norman Holdings’ 2024 and 2025 Annual Reports, which are publicly available at harveynormanholdings.com.au under the Reports & Announcements section. Both PDFs are free to download — no subscription or ASX account required. The income statement provides revenue, gross profit, EBIT, interest expense, and net profit. The balance sheet provides current assets, current liabilities, inventory, accounts receivable, total assets, total debt, and shareholders’ equity. Use the consolidated financial statements — not segment-level data — for all ratio calculations. Harvey Norman’s financial year ends 30 June, so make sure you are using FY2024 (year ended 30 June 2024) and FY2025 (year ended 30 June 2025) consistently throughout. For expert help structuring your ratio calculations and analysis, see our finance assignment help service.

How do I benchmark Harvey Norman’s ratios against industry players?
The most directly relevant Australian retail comparators are JB Hi-Fi (ASX: JBH) and Wesfarmers (ASX: WES). For each ratio category in Q3, identify the equivalent ratio for your chosen peer from their most recent annual report or a financial data service (your university library likely provides access to Morningstar, IBISWorld, or Bloomberg). The comparison should identify whether HVN is stronger, weaker, or in line with peers — and, critically, explain what that gap means for an investor. “Harvey Norman’s current ratio of [X] is below JB Hi-Fi’s [Y], which suggests HVN maintains a tighter liquidity position — acceptable given its franchise receivable structure, but worth monitoring if franchise collections slow” is a benchmarked interpretation. “Harvey Norman’s current ratio is lower than the industry” is an observation without analytical value. For sector-level benchmarking data, IBISWorld’s Australian Electrical, Electronic and Gas Appliance Retailing report provides industry-average profitability and efficiency metrics.

How do I structure Q3 — the investment recommendation report?
Q3 is a 1,000-word investment report structured around the three ratio categories. Open with a short framing paragraph (approximately 80 words) identifying the company, the period, and the purpose of the analysis. Then analyse profitability ratios in one section (approximately 270 words) — state both years’ figures, identify the trend, benchmark against a peer, and draw an investor-relevant conclusion. Do the same for liquidity and financial risk (approximately 290 words) and financial stability (approximately 160 words). Close with a recommendation section (approximately 160 words) that takes a clear buy, hold, or sell position and cites at least three specific ratio findings to support it. The recommendation must acknowledge at least one key risk or factor that could change the conclusion — this signals analytical maturity and satisfies the rubric’s implicit requirement for balanced judgment. For professional writing support on investment recommendation reports, our accounting homework help service covers financial analysis reports at this level.

Do I need to use average balance sheet figures, and how do I calculate them?
Yes — average balance sheet figures are required for ROA, ROE, inventory turnover, and accounts receivable turnover. The formula for average is: (prior year closing balance + current year closing balance) ÷ 2. To get the prior year closing balance, look at the comparative column in the current year’s annual report. The FY2024 annual report shows both FY2024 and FY2023 closing balances side by side, so you can calculate the FY2024 average directly from that document. Similarly, the FY2025 annual report shows FY2025 and FY2024 balances, giving you the FY2025 average. If you use only the single-year closing balance as the denominator, your ROA, ROE, and turnover ratios will be systematically wrong — and that error will carry into your Q3 analysis if you cite those figures to support your recommendation. Build the averaging calculation into your Excel formula from the start rather than as an afterthought.

Harvey Norman has a franchise model — does that affect how I interpret any of the ratios?
Yes, significantly — and demonstrating awareness of this distinction in Q3 is one of the ways to signal analytical depth to the marker. Harvey Norman’s balance sheet includes substantial franchisee receivables, which represent amounts owed to the company by its franchisees. These behave differently from typical retail customer receivables: they are generally longer-dated, are secured against franchisee assets in many cases, and their collection profile is tied to franchisee profitability rather than customer payment patterns. When you interpret the accounts receivable turnover ratio, note that the receivable base includes franchisee balances, which typically result in higher receivable days figures than a pure-play retailer like JB Hi-Fi would show. Similarly, Harvey Norman’s ROA is affected by its large property portfolio, which is capitalised on the balance sheet and earns rental income — this makes the asset base larger relative to operating revenue than a pure retailer’s would be, which tends to depress ROA compared to asset-light peers. Acknowledging these model-specific factors in Q3 is what separates a sophisticated analysis from a textbook application of standard formulas.

Can I recommend Harvey Norman as a buy even if some ratios look weak?
Yes — the recommendation does not need to be uniformly positive or negative. Real investment recommendations acknowledge trade-offs. A buy recommendation despite, for example, a high debt-to-equity ratio is defensible if you explain that the interest coverage ratio remains comfortable, profitability is improving, and the property asset base provides a backstop that reduces downside risk relative to the leverage level. What the rubric requires is that the recommendation is supported by specific ratio evidence — not that the evidence is all pointing in one direction. If some ratios support a buy and others argue for caution, you can recommend buy with a risk caveat, or hold while monitoring specific metrics. What you cannot do is make a recommendation that ignores the ratio evidence or is contradicted by it. For help writing investment recommendations that are analytically coherent and well-structured, see our research paper writing service or our editing and proofreading service for final review before submission.


What Your Instructor Is Looking For in a High-Scoring Submission

This assessment is testing whether you can do three things that finance graduates are expected to do in professional practice: summarise a business for a non-specialist audience, perform rigorous ratio analysis from source financial statements, and make a defensible investment recommendation backed by quantitative evidence. The marks are concentrated in Q2 (correct calculations with professional formatting) and Q3 (analysis and recommendation quality) because those are the professional skills the learning outcomes are targeting.

The students who score highest on this assessment are not the ones who calculate every ratio correctly — though that is necessary. They are the ones who interpret each ratio with specificity, connect the interpretation to Harvey Norman’s actual business context, compare against named peers with cited figures, and build a recommendation that is traceable back to the ratio evidence. That is the standard of work that earns distinction marks, and it is achievable if you approach the assessment with the same analytical discipline an investment banking analyst would apply to a real client brief.

If you need professional support with this assessment — whether that is help structuring your Excel model, developing the ratio analysis, researching peer benchmarks, or writing and editing the Q3 investment report — the team at Smart Academic Writing covers Australian university finance assessments at all levels. Visit our finance assignment help service, our accounting homework help service, our data analysis help service, or our Australian university assignment help page. You can also visit our editing and proofreading service if your draft is written and you need a final review before the Week 9 deadline.

document.querySelectorAll(‘.faq-q’).forEach(q=>{
q.addEventListener(‘click’,()=>{
const item=q.parentElement;
const wasOpen=item.classList.contains(‘open’);
document.querySelectorAll(‘.faq-item’).forEach(i=>i.classList.remove(‘open’));
if(!wasOpen)item.classList.add(‘open’);
});
});

The post Harvey Norman Ratio Analysis Assignment appeared first on Smart Academic Writing.

Plagiarism Free Assignment Help

Expert Help With This Assignment — On Your Terms

  • Native UK, USA & Australia writers
  • 100% Plagiarism-Free — Turnitin report included
  • Deadline from 3 hours
  • Unlimited free revisions
  • Free to submit — compare quotes
AD
adminblink
Academic Expert · Topessayz

Expert academic writer and education specialist helping students in the UK, USA, and Australia achieve their best results.

Need help with your own assignment?

Our expert writers can help you apply everything you've just read — to your actual assignment, brief, and marking criteria.

Get Expert Help Now →
Related Articles

You May Also Find Helpful

View All Articles →
📝 Free Submission — No Card Required

Need Help With This Assignment?

Our verified experts deliver 100% original, plagiarism-free work to your exact brief and marking criteria. Submit free — compare quotes — choose your expert.

Write My Assignment FREE Get A Free Quote →

No credit card · No commitment · First quote in minutes