FINANCE WORK
Financial analysis
for business decisions.
Agricultural credit analysis, cash-flow modeling, NPV, investment research, and property valuation support.
Business analysis, investment research & valuation support
Agricultural credit: dairy expansion review
For an independent fictional educational case, I built an integrated 2023–2029 Excel model for a 650-cow dairy’s $2 million expansion and $1.5 million term loan. The analysis linked production, financial statements, and amortization, then tested term debt coverage, DSCR, working capital, collateral lien priority, and milk-price, feed-cost, production, and interest-rate stresses.
I recommended declining the proposed structure at 1.08× term coverage against the case’s 1.25× minimum, documenting conditions for reconsideration in a credit memorandum and committee presentation.
View the model, credit memo, and presentation →
Business cash flows & NPV
Through Valcero, I build projected cash-flow models and net present value analyses to evaluate proposed business initiatives. I assess operating costs and improvement opportunities, then turn research and assumptions into actionable recommendations.
Property valuation support
As a Residential Real Estate Appraisal Analyst at Jaeger Appraisals, I research comparable sales, property characteristics, and market trends for mortgage-related assignments. I validate property data, coordinate inspections, and support 10+ appraisal reports weekly, providing documented valuation support to lenders and appraisers.
Equity research for a $2 million portfolio
As an Equity Analyst in UW Oshkosh’s Student Managed Endowment Fund in fall 2025, I researched companies, industries, financial statements, valuation metrics, and business risks. I presented investment recommendations to peers and faculty.
Discounted cash-flow modeling
My independent Tesla DCF study combines segment forecasts, reinvestment, scenarios, and an enterprise-to-equity bridge. It is a retrospective educational model, with an editable workbook and methodology PDF.
Public-budget analysis
Compared spending trends using inflation and enrollment adjustments, then presented findings during a school-board staffing discussion.
Explore the analysis approach →
Resource allocation
On the Student Allocation Committee, I evaluated funding requests and resource trade-offs involving approximately $500,000–$600,000 in annual allocations.
View five credit and finance course/simulation completions · Read the Honors research
INTERACTIVE WORK SAMPLE
Cash-flow & NPV explorer.
Illustrative figures for a fictional project. Change the assumptions to see their effect.
PRESENT VALUE OF NET CASH FLOWS, LESS INITIAL INVESTMENT
| Year | Cash flow | Present value |
|---|
NPV = −initial investment + Σ cash flowₜ ÷ (1 + rate)ᵗ. Cash flows occur at year-end. No terminal value is included. Use net cash flows that already reflect the costs relevant to your scenario.
How to interpret the model
A positive NPV means the projected cash flows exceed the initial investment after discounting at the chosen rate. Results depend on the assumptions and do not measure every business risk. This fictional example demonstrates the calculation; it is not a client result or an investment recommendation.