On this page
Your assignment
Role: Junior analyst supporting Cedar Works' controller and finance manager
Deliverable: A four-page calculation appendix plus a two-page memo to the controller and finance manager that reports verified results, assumptions, disciplinary boundaries, stop conditions, and specific missing evidence without recommending a product or accounting treatment.
Evidence basis: fictional
Evaluation criteria
- timeline rate and scope controls (25%): Declares every valuation date, cash-flow date, interval, rate type, rate conversion, period count, viewpoint, assumption, and exclusion before calculating.
- technical accuracy and reconciliation (35%): Computes all single-sum, effective-rate, annuity, payment, and schedule amounts at full precision and passes inverse, timing, row, principal, interest, and ending-balance checks.
- accounting and finance boundaries (20%): Separates accounting authority and measurement objectives from finance rate judgment and avoids recognition, fair-value, guarantee, affordability, or recommendation claims.
- communication and evidence requests (20%): Presents traceable tables and gives each audience concise supported conclusions, stop conditions, and specific next evidence requests.
Your role
Cedar Works' controller and finance manager have received a spreadsheet with three tabs. It reports a required equipment-fund deposit, calls two service-plan payment patterns “the same,” and shows one total loan payment with no principal- interest schedule. The workbook contains no timeline, rate conversion, source boundary, or rounding policy.
Replace it with a controlled analysis using the fictional Cedar Works financing and planning facts.
Required calculation appendix
Equipment fund
- Draw the month-zero to month-36 timeline.
- Convert the 4.8% stated annual quote to a monthly periodic rate and an effective annual rate.
- Compute the month-zero amount equivalent to the $60,000 month-36 target.
- Compound the full-precision result back to the target and explain any display-rounding difference.
Service plan
- Draw the four-payment ordinary and due timelines.
- Compute present and future values for both alternatives.
- Reconcile each due value to the matching ordinary value times
1.05. - Explain why the comparison isolates timing and does not rank service quality or contract terms.
Equipment loan
- Convert the 6% stated annual quote to the monthly periodic rate and EAR.
- Compute the 48-payment analytical level payment.
- Build all 48 full-precision schedule rows.
- Reconcile every row, the opening-to-ending chain, total principal, total interest, total payments, and ending balance.
- Show months 1, 2, 12, 24, 36, and 48 in the main appendix and retain the complete schedule as supporting work.
Memo
For the controller, distinguish a correct mathematical present value from an authorized accounting measurement and list the accounting guidance and input evidence still needed before recognition or disclosure.
For the finance manager, report the conditional calculations and list the rate, risk, fee, tax, product, liquidity, affordability, and contractual evidence still needed before a decision.
Do not call the saving rate guaranteed, the computed present value fair value, the service alternative preferable, or the loan affordable. Do not combine the three independent scenarios into one NPV or recommendation.
Presentation policy
Retain full precision in calculations. Display USD to cents and percentages to four decimal places. Label every amount with its date and every rate with its interval. Identify the analytical no-rounding policy beside the loan schedule.