The Internora

Internship field

Finance & Accounting

A hands-on finance and accounting track using practical spreadsheets and a small business case.

BookkeepingExcelFinancial statementsBudgetingRatio analysisReporting
Program length:4 weeks · PKR 700

Week 1 — Accounting foundations

Learn the language and structure of business accounts.

Objectives

  • Accounts
  • Transactions
  • Controls

Tasks (3)

  1. 1. Accounting glossary

    Define 25 accounting terms with simple examples.

    Deliverable: PDF.

    10 pts

  2. 2. Transaction exercise

    Record a set of fictional transactions using debits and credits.

    Deliverable: Spreadsheet.

    20 pts

  3. 3. Control checklist

    Create a basic cash and records control checklist for a small business.

    Deliverable: PDF.

    15 pts

Week 2 — Financial statements

Build and interpret core statements.

Objectives

  • Income statement
  • Balance sheet
  • Cash flow

Tasks (3)

  1. 1. Income statement

    Prepare a simple monthly income statement from provided transactions.

    Deliverable: Spreadsheet.

    20 pts

  2. 2. Balance sheet

    Prepare a simple balance sheet and verify that it balances.

    Deliverable: Spreadsheet.

    20 pts

  3. 3. Cash flow summary

    Create a cash flow summary and explain the biggest movements.

    Deliverable: Spreadsheet + notes.

    15 pts

Week 3 — Budgeting and analysis

Use numbers to support business decisions.

Objectives

  • Budget
  • Variance
  • Ratios

Tasks (3)

  1. 1. Monthly budget

    Create a 12-line operating budget for a fictional business.

    Deliverable: Spreadsheet.

    20 pts

  2. 2. Variance analysis

    Compare actuals to budget and explain five material variances.

    Deliverable: Spreadsheet.

    20 pts

  3. 3. Ratio analysis

    Calculate and interpret at least six financial ratios.

    Deliverable: Spreadsheet + PDF.

    20 pts

Week 4 — Finance case study

Final project

Present a clear financial recommendation.

Objectives

  • Forecasting
  • Scenario analysis
  • Reporting

Tasks (3)

  1. 1. Forecast

    Build a three-month revenue and expense forecast with assumptions.

    Deliverable: Spreadsheet.

    25 pts

  2. 2. Scenario analysis

    Create base, cautious and growth scenarios and explain key drivers.

    Deliverable: Spreadsheet.

    20 pts

  3. 3. Final finance report

    Write an executive report with findings, risks and recommendations.

    Deliverable: PDF.

    30 pts