Oracle Tutoring, Campbell River, BC
(250) 203-6544 (text) or (250) 830-0295 (talk)
The tutor points out a very convenient utility. I haven’t upgraded to Windows 10, so am still running Windows 7. From the Start menu (the circle with the colored window panes), if I click All Programs, then Accessories, the desktop …
Math: calculating mortgage payment on the Windows desktop calculator Read more »
The tutor shares a really neat find from the world of accounting. Although I’m an academic, the first post-secondary diploma I received, believe it or not, was in accounting and office management. While I haven’t used it much professionally, what …
Accounting and Business: Depreciation: Sum-of-years’-digits method Read more »
The tutor shows how to use a spreadsheet (Excel) to compute a recursive deduction rate using a circular reference. In yesterday’s post I brought up an example in which a deduction depends upon the income minus that same deduction. It’s …
Spreadsheets: Excel circular reference: recursive deduction calculation Read more »
Sometimes, deduction rates can be tricky. The tutor offers an example of a “circular argument.” Let’s imagine a benevolent employer offers a health plan that costs 6% of the employee’s net income. The company’s definition of net income is gross …
The tutor shows an example of naming items in a spreadsheet for use in a formula. This post focuses on Microsoft Excel; hopefully I’ll do a similar one for a generic spreadsheet soon. Let’s imagine Jones faces two tax rates: …
The tutor answers a question that brought someone to his site. These days, Oracle Tutoring gets between 5000 and 6000 distinct visitors per month. Looking over the raw log entries of how some visitors arrived, I saw an inquiry yesterday …
The tutor continues exploring annuities. In my previous post I introduced the idea of an annuity with an example. That example had each payment at month’s-end; hence, it was an ordinary annuity. With an annuity due, the payment is …
Financial math: ordinary annuity versus annuity due Read more »
Financial math awaits many students. The tutor introduces annuities. From the point of view of a typical consumer, an annuity is the reverse of a loan. The consumer becomes the lender, while the institution pays them back, often with monthly …
A lifetime ago, the tutor studied financial planning. That’s when he got acquainted with the HP-10B. Of the financial calculators I know, the Hewlett-Packard HP-10B is potentially the easiest to use. One feature of particular value to anyone in financial …
Financial math: interest rate conversions on the HP-10B Read more »
Tutoring high school math, you don’t always see financial calculators; more often, you might see the TI-83 grapher. The tutor recalls the TI BA-35’s use in accounting courses…. The TI BA-35 is a classic among financial calculators. It’s got that …
Equivalent annual rate, continued: finding it on the TI BA-35 Read more »