← Asset-finance pricing calculator

Workbook map: pricing_calculator.xlsx

Generated by Power Migrate 0.1.0a1. SHA-256 d2a7b89598fa1cf428dd9b55a51598c73cba8749b6527613cf279f1d8c2f4f0e.

At a glance

Measure Value
Sheets 6 (0 hidden)
Populated cells 846
Formula cells 641
Logic blocks (formula patterns) 52
Input cells (constants read by formulas) 139
Output cells (formulas nothing else reads) 97
Defined names 8 (0 broken)
Distinct functions used 30
Feature flags raised 19

Sheets

Sheet State Cells Formulas Blocks Inputs Outputs
Inputs visible 37 6 6 10 4
RateCard visible 57 4 4 45 0
Schedule visible 661 578 13 73 73
Economics visible 27 13 13 0 12
Sensitivity visible 47 32 8 11 2
Summary visible 17 8 8 0 6

Sheet by sheet

How the sheets connect

Arrows point from the sheet doing the reading to the sheet being read; the number is how many formulas make that read.

graph LR
    S0["Inputs"]
    S1["RateCard"]
    S2["Schedule"]
    S3["Economics"]
    S4["Sensitivity"]
    S5["Summary"]
    S3 -->|10| S0
    S3 -->|4| S1
    S3 -->|5| S2
    S1 -->|2| S0
    S2 -->|578| S0
    S2 -->|215| S1
    S4 -->|30| S0
    S4 -->|30| S1
    S5 -->|1| S3
    S5 -->|6| S0
    S5 -->|2| S1
    S5 -->|3| S2

Functions used

Function Uses Converted
IF 577 yes
PMT 103 yes
EDATE 75 yes
PPMT 72 yes
IPMT 71 yes
MATCH 2 yes
COUNTIF 2 yes
TEXT 2 yes
ROUND 1 yes
NETWORKDAYS 1 yes
WORKDAY 1 yes
DATEDIF 1 yes
YEARFRAC 1 yes
INDEX 1 yes
XLOOKUP 1 yes
SUM 1 yes
SUMPRODUCT 1 yes
MAXIFS 1 yes
NPV 1 yes
IRR 1 yes
RATE 1 yes
PV 1 yes
FV 1 yes
NPER 1 yes
MIN 1 yes
IFS 1 yes
SWITCH 1 yes
TEXTJOIN 1 yes
AND 1 yes
AVERAGEIF 1 yes

Defined names

Name Scope Refers to Status
APR workbook RateCard!$B$12 ok
AssetCost workbook Inputs!$B$3 ok
Balloon workbook Inputs!$B$17 ok
Financed workbook Inputs!$B$16 ok
Hurdle workbook Inputs!$B$12 ok
MonthlyRate workbook RateCard!$B$13 ok
StartDate workbook Inputs!$B$7 ok
TermMonths workbook Inputs!$B$5 ok

Features and risks found

Everything here is detected deterministically. Items marked as stubbed appear as UNSUPPORTED in the generated code and as not converted in the reconciliation report.

Feature Count What it means Examples
hard_coded_literal 18 Numbers typed into formulas rather than held in input cells Inputs!B20 (12), RateCard!B12 (10000), RateCard!B13 (12), and 15 more
cached_error 1 Cell showed an Excel error when the workbook was saved Economics!B5 (#VALUE!)