Create a prompt that insructs the AI to come up with a structual way I would contuct my loan stratergy (different bank accounts, using investnow etc.) based on the following chat: Here’s a full **summary of your student loan and financial strategy discussion**, including legal analysis and spreadsheet details:

---

## 🧠 **Overall Strategy Summary**

You are a New Zealand student planning to complete a **5-year double degree (LLB/BCom) at the University of Otago**. Your financial strategy is:

### ✅ Key Strategic Components:

1. **Maximise borrowing** from the Student Loan Scheme — including full **Living Costs** and **Course-Related Costs**.
2. **Minimise personal expenses** by budgeting carefully.
3. **Invest money from family contributions and summer job earnings**, rather than spending it, in **low-risk financial instruments**.
4. **Delay repaying the student loan** until you're legally required — especially if planning to stay in NZ to keep it **interest-free**.
5. **Repay in full** or substantially **before going overseas**, to avoid **interest accrual** and forced repayments.

---

## 📊 **Financial Spreadsheet Template Summary**

A comprehensive Excel spreadsheet was created with the following:

### 1. **Estimated Expenses Statement**:

* Duration: **Year 1 to Year 5** + a **Total column**.
* Key categories include:

  * **Tuition Fees** (set to **0 in Year 5** to reflect *Fees-Free* eligibility).
  * **Accommodation**: Residential college in Year 1; flatting with rising CPI-adjusted rent in Years 2–5.
  * **Food**, **Utilities**, **Transport**, **Books & Course Materials**, **Personal**, **Travel**, **Insurance**, etc.
* Inflation adjustments applied via **mid-band CPI (approx. 3%)** annually.

### 2. **Estimated Sources of Finance**:

* Includes:

  * Opening Balance (Savings)
  * Family Contributions
  * Scholarships/Grants
  * **Student Loan – Fees**
  * **Student Loan – Living Costs (Max)**
  * Part-time/Summer Job Income
  * Studylink Allowance (if eligible)
  * Other income (e.g., investment returns)

### 3. **Pro Forma Cash Flow Statement**:

* Tracks **cash inflows vs outflows** across the 5 years.
* Highlights:

  * Inflows: Loans, earnings, gifts.
  * Outflows: Expenses, including a **“Student Loan Principal Repayment” row** (for lump-sum modelling in Year 5).
  * Net cash flow, **opening/closing balances**, and year-end liquidity position.

### 4. **Pro Forma Income Statement**:

* Shows **total annual income** (excluding loan principal, including potential investment income).
* Lists **total expenses**, giving an annual **surplus/deficit**.

### 5. **Break-Even Analysis**:

* Calculates how much non-loan income is required over 5 years to **fully fund study costs** (excluding loan repayment).
* Allows you to determine your **financial independence gap**.

---

## 📈 **Investment Strategy & Questions Addressed**

### 1. **Beyond Term Deposits – Low-Risk Investments**:

* **NZ Government Bonds**
* **Cash PIE funds** (tax-efficient interest-bearing)
* **Laddered Term Deposits**
* **High-interest savings accounts**
* **Short-term fixed-income ETFs** (more risk than deposits)
* All options are **low-risk**, liquid, and appropriate for a student with short-to-medium investment horizons.

### 2. **Realism of Investing the Full \$8,000/Year**:

* With careful budgeting and full loan support, investing **\$5,000–\$8,000/year is realistic**.
* Requires:

  * Low spending during the year.
  * Saving family gifts and summer income (\~\$10,000 annually).
  * Living within the **Living Cost loan + minimal side income**.

---

## 🚨 **Legal Analysis of Your Strategy**

### ✅ **What’s Legal:**

* **Maximising Student Loan borrowing** — no restrictions on what you use Living Costs or Course-Related Costs for.
* **Delaying repayment** — legal while studying full-time or earning under the threshold.
* **Investing the loan or gifts** — not restricted under Studylink or IRD rules.

### ⚠️ **Risks/Limitations**:

* **Leaving NZ for more than 6 months** triggers:

  * **Interest on your loan**.
  * **Obligation to repay regardless of income**.
* **Misreporting income, location, or enrollment** is **fraud**.
* Using artificial structures to dodge income-based repayment might be challenged under **anti-avoidance laws**.

---

## 💼 Final Notes & Tools Available

### Provided:

* A downloadable **Excel spreadsheet** with all 5-year financial modelling, inflation-adjusted costs, and integrated loan strategy.

### Optional Add-Ons:

* A **visual dashboard or graph** version of your cash flow and loan accumulation.
* A **checklist** of legal/financial deadlines (e.g., when to notify IRD if travelling, when repayments begin, etc.).
* An **investment return calculator** for your projected savings vs loan.

Would you like me to generate a **repayment simulation** or **loan vs investment return model** next?