20230223 - Simple Financial Model_v24.xlsx

CHIPS Pre-Application Information Collection

20230223 - Simple Financial Model_v24.xlsx

OMB: 0693-0095

Document [xlsx]
Download: xlsx | pdf

Overview

Overview
Inputs >>
Control Panel
Processing >>
Assumptions Processing
Depreciation Schedule
Outputs >>
Income Statement
CashFlow
Balance Sheet
Other >>
Drop-Downs


Sheet 1: Overview

















Introduction to the Pre-App Project Forecasting Example Tool











Purpose: The purpose of this document is to provide an example of the level of granularity and structure for the summary project financials for the purposes of the Pre-App. This document is an example, is not expected to be completed, and will not be collected.







Description of contents











Worksheet Legend:




Worksheet
Description


Inputs >> Control Panel Main tab for the user that controls assumptions and inputs


Processing >> Assumptions Processing Helper worksheet to structure inputs for model outputs


Depreciation Schedule Helper worksheet to calculate depreciation and investment tax credit


Outputs >> Income Statement Model output summarizing income statement for the project


CashFlow Model output summarizing a cash flow statement for the project


Balance Sheet Model output summarizing a balance sheet for the project


Other >> Drop-downs Helper worksheet to define options in tool’s drop downs

Sheet 2: Inputs >>

Input >>
See the following tabs (Control Panel) directly following this tab

Sheet 3: Control Panel

Control Panel






















Main tab for the user that controls assumptions and inputs















































(A) Overview







Error Checks: Notes

















Direct input

Inputs - - Checks that inputs are sensible (e.g., sum to 100%, no negative cost / loans / etc)












Enter Project/Company Name CPO Semiconductor Manufacturing Project
Interim calculation Text
Cash balances - - Checks if cash balances are positive for the entire forecast

















Cross sheet reference

Balance sheet - - Checks if the B/S reconciles




































(B) Project Capital Costs
























Check




















Total Initial Capital Investment 8,000,000,000 0




















Total Capital Allocated 8,000,000,000 0












































Size and timing of initial Capital Investment spend
Year





















Amount 1 2 3 4 5 Total Check














Land 100,000,000 100% 0% 0% 0% 0% 100% 0














Construction 1,100,000,000 50% 50% 0% 0% 0% 100% 0














Equipment 6,000,000,000 0% 50% 50% 0% 0% 100% 0














Administrative Expenses directly attributable to facility construction 100,000,000 25% 25% 50% 0% 0% 100% 0














Infrastructure Improvements 100,000,000 25% 25% 50% 0% 0% 100% 0














Other Capital Investment 600,000,000 25% 25% 50% 0% 0% 100% 0






































Ongoing annual capital investment (after facility initiates operation)
Check




















Annual cost as a % of initial capital investment spend 4% 0




















Start year 4 0












































(C) Project Revenue
























Check




















Unit production capacity, Monthly 20,000 0




















Unit price in first year of production 16,000 0




















Annual change in unit price -5%














































Start year End year # years Check


















Unit production ramp up (% of total capacity) 2 4 3 0










































(D) Operating Costs















































Run Rate Cost Annual change after production ramp up
Check


















Materials / Consumables / Chemicals 500,000,000 -3%
0


















Labor 400,000,000 0%
0


















Utilities 200,000,000 -2%
0


















SG&A 300,000,000 -5%
0


















R&D 150,000,000 -8%
0


















[Other Costs #1] 0 0%
0


















[Other Costs #2] 0 0%
0


















[Other Costs #3] 0 0%
0










































(E) Debt Assumptions















































Senior debt Subordinated debt Check



















Annual interest rate (%) 5.00% 8.00% 0



















Tenor (years) 10 8 0



















Amortization start (year) 4 4 0



















Loan structure Amortizing Amortizing




















Total loan amount 1,500,000,000 1,500,000,000 0



















Loan disbursement start 1 1 0



















Loan disbursement end 3 3 0



















# years 3 3












































(F) Project Financing Assumptions














































Size and timing of Equity and Grant Contributions
Year





















Amount 1 2 3 4 5 Total Check














Equity Contributions 5,000,000,000 33% 33% 33% 0% 0% 100% 0














CHIPS Direct Funding Contributions 0 33% 33% 33% 0% 0% 100% 0














State and Local Incentives 0 33% 33% 33% 0% 0% 100% 0






































(G) Tax Assumptions
























Check




















Tax Rate 21% 0




















Investment Tax Credit (ITC) rebate 25% 0




















% of Qualifying Depreciable Capex for ITC 82% 0












































(H) Depreciation Assumptions






















Years Check




















Construction 15 0




















Equipment 6 0




















Administrative Expenses directly attributable to facility construction 6 0




















Infrastructure Improvements 6 0




















Other Capital Investment 6 0




















Ongoing annual capital investment (after facility initiates operation) 6 0












































(I) Working Capital Assumptions
























Check




















Days in Receivables 30 0




















Days Inventory 30 0




















Days in Payables 30 0




















Months Debt Service to Restricted Cash 6 0












































(J) Distributions
























Check




















Year distributions start 5 0




















Minimum cash balance 150,000,000 0












































Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20


Period Cash Balance (Pre Distribution) 1,937,916,667 2,210,353,556 3,236,610,581 4,045,177,960 4,806,144,563 813,325,771 714,016,330 534,823,622 721,622,222 770,791,986 825,192,801 755,078,984 688,585,343 625,536,266 565,764,099 502,987,333 443,174,782 392,302,290 344,109,428 298,463,720


Period Cash Balance (Post distribution) 1,937,916,667 2,210,353,556 3,236,610,581 4,045,177,960 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000


Distribution 0 0 0 0 4,656,144,563 663,325,771 564,016,330 384,823,622 571,622,222 620,791,986 675,192,801 605,078,984 538,585,343 475,536,266 415,764,099 352,987,333 293,174,782 242,302,290 194,109,428 148,463,720


























Cash Balance Check 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


Sheet 4: Processing >>

Processing >>
See the following tabs (Assumptions Processing, Depreciation Schedule) directly following this tab

Sheet 5: Assumptions Processing

Assumptions Processing






















Helper worksheet to structure inputs for model outputs

Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

























Project Capital Costs














































Land

100,000,000 - - - - - - - - - - - - - - - - - - -

Construction

550,000,000 550,000,000 - - - - - - - - - - - - - - - - - -

Equipment

- 3,000,000,000 3,000,000,000 - - - - - - - - - - - - - - - - -

Administrative Expenses directly attributable to facility construction

25,000,000 25,000,000 50,000,000 - - - - - - - - - - - - - - - - -

Infrastructure Improvements

25,000,000 25,000,000 50,000,000 - - - - - - - - - - - - - - - - -

Other Capital Investment

150,000,000 150,000,000 300,000,000 - - - - - - - - - - - - - - - - -

Ongoing annual capital investment (after facility initiates operation)

- - - 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000

Total Annual Capital Expenditures
850,000,000 3,750,000,000 3,400,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000

























Project Revenue














































Production

- 80,000 160,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000 240,000

Price per Unit (USD)

16,000 16,000 15,200 14,440 13,718 13,032 12,380 11,761 11,173 10,615 10,084 9,580 9,101 8,646 8,213 7,803 7,413 7,042 6,690 6,355

Net Sales

- 1,280,000,000 2,432,000,000 3,465,600,000 3,292,320,000 3,127,704,000 2,971,318,800 2,822,752,860 2,681,615,217 2,547,534,456 2,420,157,733 2,299,149,847 2,184,192,354 2,074,982,737 1,971,233,600 1,872,671,920 1,779,038,324 1,690,086,408 1,605,582,087 1,525,302,983

























Operating Costs














































Materials / Consumables / Chemicals

- 166,666,667 333,333,333 500,000,000 485,000,000 470,450,000 456,336,500 442,646,405 429,367,013 416,486,002 403,991,422 391,871,680 380,115,529 368,712,063 357,650,702 346,921,180 336,513,545 326,418,139 316,625,595 307,126,827

Labor

- 133,333,333 266,666,667 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000

Utilities

- 66,666,667 133,333,333 200,000,000 196,000,000 192,080,000 188,238,400 184,473,632 180,784,159 177,168,476 173,625,107 170,152,605 166,749,552 163,414,561 160,146,270 156,943,345 153,804,478 150,728,388 147,713,821 144,759,544

SG&A

- 100,000,000 200,000,000 300,000,000 285,000,000 270,750,000 257,212,500 244,351,875 232,134,281 220,527,567 209,501,189 199,026,129 189,074,823 179,621,082 170,640,028 162,108,026 154,002,625 146,302,494 138,987,369 132,038,001

R&D

- 50,000,000 100,000,000 150,000,000 138,000,000 126,960,000 116,803,200 107,458,944 98,862,228 90,953,250 83,676,990 76,982,831 70,824,204 65,158,268 59,945,607 55,149,958 50,737,961 46,678,925 42,944,611 39,509,042

[Other Costs #1]

- - - - - - - - - - - - - - - - - - - -

[Other Costs #2]

- - - - - - - - - - - - - - - - - - - -

[Other Costs #3]

- - - - - - - - - - - - - - - - - - - -

Total Operating Costs

- 516,666,667 1,033,333,333 1,550,000,000 1,504,000,000 1,460,240,000 1,418,590,600 1,378,930,856 1,341,147,682 1,305,135,296 1,270,794,708 1,238,033,245 1,206,764,109 1,176,905,975 1,148,382,606 1,121,122,510 1,095,058,609 1,070,127,945 1,046,271,395 1,023,433,413

























Senior Debt Assumptions and Schedule





























Anchor Date














Outstanding Principal (Start of Year)

- 500,000,000 1,000,000,000 1,500,000,000 1,315,770,272 1,122,329,058 919,215,784 705,946,845 482,014,460 246,885,455 - - - - - - - - - -

Draws on Principal

500,000,000 500,000,000 500,000,000 - - - - - - - - - - - - - - - - -

Senior Debt Principal Repayments

- - - 184,229,728 193,441,214 203,113,275 213,268,938 223,932,385 235,129,005 246,885,455 - - - - - - - - - -

Outstanding Principal (End of Year)

500,000,000 1,000,000,000 1,500,000,000 1,315,770,272 1,122,329,058 919,215,784 705,946,845 482,014,460 246,885,455 - - - - - - - - - - -

























Senior Debt Interest

12,500,000 37,500,000 62,500,000 70,394,257 60,952,483 51,038,621 40,629,066 29,699,033 18,222,498 6,172,136 - - - - - - - - - -

Total Senior Debt Service

- - - 184,229,728 193,441,214 203,113,275 213,268,938 223,932,385 235,129,005 246,885,455 - - - - - - - - - -

























Subordinated Debt -- Assumptions and Schedule





























Anchor Date














Outstanding Principal (Start of Year)

- 500,000,000 1,000,000,000 1,500,000,000 1,244,315,318 968,175,862 669,945,249 347,856,187 - - - - - - - - - - - -

Draws on Principal

500,000,000 500,000,000 500,000,000 - - - - - - - - - - - - - - - - -

Subordinated Debt Principal Repayments

- - - 255,684,682 276,139,456 298,230,613 322,089,062 347,856,187 - - - - - - - - - - - -

Outstanding Principal (End of Year)

500,000,000 1,000,000,000 1,500,000,000 1,244,315,318 968,175,862 669,945,249 347,856,187 - - - - - - - - - - - - -

























Subordinated Debt Interest

20,000,000 37,500,000 62,500,000 68,607,883 55,312,279 40,953,028 25,445,036 8,696,405 - - - - - - - - - - - -

Total Subordinated Debt Service

- - - 255,684,682 276,139,456 298,230,613 322,089,062 347,856,187 - - - - - - - - - - - -

























Grant Assumptions














































Equity Contributions

1,666,666,667 1,666,666,667 1,666,666,667 - - - - - - - - - - - - - - - - -

CHIPS Direct Funding Contributions

- - - - - - - - - - - - - - - - - - - -

State and Local Incentives

- - - - - - - - - - - - - - - - - - - -

























Depreciation Assumptions













































Construction

29,150,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 29,150,000 - - - -

Equipment

- 397,500,000 795,000,000 795,000,000 795,000,000 795,000,000 795,000,000 397,500,000 - - - - - - - - - - - -

Administrative Expenses directly attributable to facility construction

3,312,500 6,625,000 13,250,000 13,250,000 13,250,000 13,250,000 9,937,500 6,625,000 - - - - - - - - - - - -

Infrastructure Improvements

3,312,500 6,625,000 13,250,000 13,250,000 13,250,000 13,250,000 9,937,500 6,625,000 - - - - - - - - - - - -

Other Capital Investment

19,875,000 39,750,000 79,500,000 79,500,000 79,500,000 79,500,000 59,625,000 39,750,000 - - - - - - - - - - - -

Ongoing annual capital investment (after facility initiates operation)

- - - 53,333,333 106,666,667 160,000,000 213,333,333 266,666,667 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000

Total Annual Depreciation Exp.

55,650,000 508,800,000 959,300,000 1,012,633,333 1,065,966,667 1,119,300,000 1,146,133,333 775,466,667 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 349,150,000 320,000,000 320,000,000 320,000,000 320,000,000

Sheet 6: Depreciation Schedule

Depreciation Schedule

























Helper worksheet to calculate depreciation and investment tax credit





















































Year

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20






























Investment Tax Credit




















































ITC effective rate 21%



















































ITC Calcuation

























ITC from Construction

112,750,000 112,750,000 - - - - - - - - - - - - - - - - - -



ITC from Equipment

- 615,000,000 615,000,000 - - - - - - - - - - - - - - - - -



ITC from Administrative Expenses

5,125,000 5,125,000 10,250,000 - - - - - - - - - - - - - - - - -



ITC from Infrastructure Improvements

5,125,000 5,125,000 10,250,000 - - - - - - - - - - - - - - - - -



ITC from Other Capital Expenses

30,750,000 30,750,000 61,500,000 - - - - - - - - - - - - - - - - -



Total ITC

153,750,000 768,750,000 697,000,000 - - - - - - - - - - - - - - - - -






























Depreciation Schedule: Construction

























Construction (Capex) pre ITC

550,000,000 550,000,000 - - - - - - - - - - - - - - - - - -



Construction (Capex) post ITC

437,250,000 437,250,000 - - - - - - - - - - - - - - - - - -

Capex post ITC































Deprec. Table

























29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 - - - - -
1 437,250,000




29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 29,150,000 - - - -
2 437,250,000




- - - - - - - - - - - - - - - - - -
3 -




- - - - - - - - - - - - - - - - -
4 -




- - - - - - - - - - - - - - - -
5 -




- - - - - - - - - - - - - - -
6 -




- - - - - - - - - - - - - -
7 -




- - - - - - - - - - - - -
8 -




- - - - - - - - - - - -
9 -




- - - - - - - - - - -
10 -




- - - - - - - - - -
11 -




- - - - - - - - -
12 -




- - - - - - - -
13 -




- - - - - - -
14 -




- - - - - -
15 -




- - - - -
16 -




- - - -
17 -




- - -
18 -




- -
19 -




-
20 -




29,150,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 29,150,000 - - - -






























Depreciation Schedule: Equipment

























Equipment (Capex) pre ITC

- 3,000,000,000 3,000,000,000 - - - - - - - - - - - - - - - - -



Equipment (Capex) post ITC

- 2,385,000,000 2,385,000,000 - - - - - - - - - - - - - - - - -

Capex post ITC































Deprec. Table

























- - - - - - - - - - - - - - - - - - - -
1 -




397,500,000 397,500,000 397,500,000 397,500,000 397,500,000 397,500,000 - - - - - - - - - - - - -
2 2,385,000,000




397,500,000 397,500,000 397,500,000 397,500,000 397,500,000 397,500,000 - - - - - - - - - - - -
3 2,385,000,000




- - - - - - - - - - - - - - - - -
4 -




- - - - - - - - - - - - - - - -
5 -




- - - - - - - - - - - - - - -
6 -




- - - - - - - - - - - - - -
7 -




- - - - - - - - - - - - -
8 -




- - - - - - - - - - - -
9 -




- - - - - - - - - - -
10 -




- - - - - - - - - -
11 -




- - - - - - - - -
12 -




- - - - - - - -
13 -




- - - - - - -
14 -




- - - - - -
15 -




- - - - -
16 -




- - - -
17 -




- - -
18 -




- -
19 -




-
20 -




- 397,500,000 795,000,000 795,000,000 795,000,000 795,000,000 795,000,000 397,500,000 - - - - - - - - - - - -






























Depreciation Schedule: Administrative Expenses directly attributable to facility construction

























Admin (Capex) pre ITC

25,000,000 25,000,000 50,000,000 - - - - - - - - - - - - - - - - -



Admin (Capex) post ITC

19,875,000 19,875,000 39,750,000 - - - - - - - - - - - - - - - - -

Capex post ITC































Deprec. Table

























3,312,500 3,312,500 3,312,500 3,312,500 3,312,500 3,312,500 - - - - - - - - - - - - - -
1 19,875,000




3,312,500 3,312,500 3,312,500 3,312,500 3,312,500 3,312,500 - - - - - - - - - - - - -
2 19,875,000




6,625,000 6,625,000 6,625,000 6,625,000 6,625,000 6,625,000 - - - - - - - - - - - -
3 39,750,000




- - - - - - - - - - - - - - - - -
4 -




- - - - - - - - - - - - - - - -
5 -




- - - - - - - - - - - - - - -
6 -




- - - - - - - - - - - - - -
7 -




- - - - - - - - - - - - -
8 -




- - - - - - - - - - - -
9 -




- - - - - - - - - - -
10 -




- - - - - - - - - -
11 -




- - - - - - - - -
12 -




- - - - - - - -
13 -




- - - - - - -
14 -




- - - - - -
15 -




- - - - -
16 -




- - - -
17 -




- - -
18 -




- -
19 -




-
20 -




3,312,500 6,625,000 13,250,000 13,250,000 13,250,000 13,250,000 9,937,500 6,625,000 - - - - - - - - - - - -






























Depreciation Schedule: Infrastructure Improvements

























Infra Improvement (Capex) pre ITC

25,000,000 25,000,000 50,000,000 - - - - - - - - - - - - - - - - -



Infra Improvement (CapEx) post ITC

19,875,000 19,875,000 39,750,000 - - - - - - - - - - - - - - - - -

Capex post ITC































Deprec. Table

























3,312,500 3,312,500 3,312,500 3,312,500 3,312,500 3,312,500 - - - - - - - - - - - - - -
1 19,875,000




3,312,500 3,312,500 3,312,500 3,312,500 3,312,500 3,312,500 - - - - - - - - - - - - -
2 19,875,000




6,625,000 6,625,000 6,625,000 6,625,000 6,625,000 6,625,000 - - - - - - - - - - - -
3 39,750,000




- - - - - - - - - - - - - - - - -
4 -




- - - - - - - - - - - - - - - -
5 -




- - - - - - - - - - - - - - -
6 -




- - - - - - - - - - - - - -
7 -




- - - - - - - - - - - - -
8 -




- - - - - - - - - - - -
9 -




- - - - - - - - - - -
10 -




- - - - - - - - - -
11 -




- - - - - - - - -
12 -




- - - - - - - -
13 -




- - - - - - -
14 -




- - - - - -
15 -




- - - - -
16 -




- - - -
17 -




- - -
18 -




- -
19 -




-
20 -




3,312,500 6,625,000 13,250,000 13,250,000 13,250,000 13,250,000 9,937,500 6,625,000 - - - - - - - - - - - -






























Depreciation Schedule: Other Capital Investment

























Other (Capex) pre ITC

150,000,000 150,000,000 300,000,000 - - - - - - - - - - - - - - - - -



Other (Capex) post ITC

119,250,000 119,250,000 238,500,000 - - - - - - - - - - - - - - - - -

Capex post ITC































Deprec. Table

























19,875,000 19,875,000 19,875,000 19,875,000 19,875,000 19,875,000 - - - - - - - - - - - - - -
1 119,250,000




19,875,000 19,875,000 19,875,000 19,875,000 19,875,000 19,875,000 - - - - - - - - - - - - -
2 119,250,000




39,750,000 39,750,000 39,750,000 39,750,000 39,750,000 39,750,000 - - - - - - - - - - - -
3 238,500,000




- - - - - - - - - - - - - - - - -
4 -




- - - - - - - - - - - - - - - -
5 -




- - - - - - - - - - - - - - -
6 -




- - - - - - - - - - - - - -
7 -




- - - - - - - - - - - - -
8 -




- - - - - - - - - - - -
9 -




- - - - - - - - - - -
10 -




- - - - - - - - - -
11 -




- - - - - - - - -
12 -




- - - - - - - -
13 -




- - - - - - -
14 -




- - - - - -
15 -




- - - - -
16 -




- - - -
17 -




- - -
18 -




- -
19 -




-
20 -




19,875,000 39,750,000 79,500,000 79,500,000 79,500,000 79,500,000 59,625,000 39,750,000 - - - - - - - - - - - -






























Depreciation Schedule: Ongoing capital expenditures (after facility initiates operation)

























Ongoing Capital Expenditures (CapEx)

- - - 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000

Capex post ITC































Deprec. Table

























- - - - - - - - - - - - - - - - - - - -
1 -




- - - - - - - - - - - - - - - - - - -
2 -




- - - - - - - - - - - - - - - - - -
3 -




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - - - - - - - - - -
4 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - - - - - - - - -
5 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - - - - - - - -
6 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - - - - - - -
7 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - - - - - -
8 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - - - - -
9 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - - - -
10 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - - -
11 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - - -
12 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 - -
13 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 -
14 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333 53,333,333
15 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333 53,333,333
16 320,000,000




53,333,333 53,333,333 53,333,333 53,333,333
17 320,000,000




53,333,333 53,333,333 53,333,333
18 320,000,000




53,333,333 53,333,333
19 320,000,000




53,333,333
20 320,000,000




- - - 53,333,333 106,666,667 160,000,000 213,333,333 266,666,667 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000



Sheet 7: Outputs >>

Outputs>>
See the following tabs (Income Statement, CashFlow, & Balance Sheet) directly following this tab

Sheet 8: Income Statement

Income Statement






















Model output summarizing income statement for the project















































Year

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

























Operating Income






















Net Sales

- 1,280,000,000 2,432,000,000 3,465,600,000 3,292,320,000 3,127,704,000 2,971,318,800 2,822,752,860 2,681,615,217 2,547,534,456 2,420,157,733 2,299,149,847 2,184,192,354 2,074,982,737 1,971,233,600 1,872,671,920 1,779,038,324 1,690,086,408 1,605,582,087 1,525,302,983

Other Operating Income

- - - - - - - - - - - - - - - - - - - -

CHIPS Direct Funding Contributions

- - - - - - - - - - - - - - - - - - - -

State and Local Incentives

- - - - - - - - - - - - - - - - - - - -

Total Revenue

- 1,280,000,000 2,432,000,000 3,465,600,000 3,292,320,000 3,127,704,000 2,971,318,800 2,822,752,860 2,681,615,217 2,547,534,456 2,420,157,733 2,299,149,847 2,184,192,354 2,074,982,737 1,971,233,600 1,872,671,920 1,779,038,324 1,690,086,408 1,605,582,087 1,525,302,983

























Operating Expenses






















Materials / Consumables / Chemicals

- 166,666,667 333,333,333 500,000,000 485,000,000 470,450,000 456,336,500 442,646,405 429,367,013 416,486,002 403,991,422 391,871,680 380,115,529 368,712,063 357,650,702 346,921,180 336,513,545 326,418,139 316,625,595 307,126,827

Labor

- 133,333,333 266,666,667 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000 400,000,000

Utilities

- 66,666,667 133,333,333 200,000,000 196,000,000 192,080,000 188,238,400 184,473,632 180,784,159 177,168,476 173,625,107 170,152,605 166,749,552 163,414,561 160,146,270 156,943,345 153,804,478 150,728,388 147,713,821 144,759,544

SG&A

- 100,000,000 200,000,000 300,000,000 285,000,000 270,750,000 257,212,500 244,351,875 232,134,281 220,527,567 209,501,189 199,026,129 189,074,823 179,621,082 170,640,028 162,108,026 154,002,625 146,302,494 138,987,369 132,038,001

R&D

- 50,000,000 100,000,000 150,000,000 138,000,000 126,960,000 116,803,200 107,458,944 98,862,228 90,953,250 83,676,990 76,982,831 70,824,204 65,158,268 59,945,607 55,149,958 50,737,961 46,678,925 42,944,611 39,509,042

[Other Costs #1]

- - - - - - - - - - - - - - - - - - - -

[Other Costs #2]

- - - - - - - - - - - - - - - - - - - -

[Other Costs #3]

- - - - - - - - - - - - - - - - - - - -

Total Operating Expenses

- 516,666,667 1,033,333,333 1,550,000,000 1,504,000,000 1,460,240,000 1,418,590,600 1,378,930,856 1,341,147,682 1,305,135,296 1,270,794,708 1,238,033,245 1,206,764,109 1,176,905,975 1,148,382,606 1,121,122,510 1,095,058,609 1,070,127,945 1,046,271,395 1,023,433,413

























Depreciation Expense






















Construction

29,150,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 58,300,000 29,150,000 - - - -

Equipment

- 397,500,000 795,000,000 795,000,000 795,000,000 795,000,000 795,000,000 397,500,000 - - - - - - - - - - - -

Administrative Expenses directly attributable to facility construction

3,312,500 6,625,000 13,250,000 13,250,000 13,250,000 13,250,000 9,937,500 6,625,000 - - - - - - - - - - - -

Infrastructure Improvements

3,312,500 6,625,000 13,250,000 13,250,000 13,250,000 13,250,000 9,937,500 6,625,000 - - - - - - - - - - - -

Other Capital Investment

19,875,000 39,750,000 79,500,000 79,500,000 79,500,000 79,500,000 59,625,000 39,750,000 - - - - - - - - - - - -

Ongoing annual capital investment (after facility initiates operation)

- - - 53,333,333 106,666,667 160,000,000 213,333,333 266,666,667 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000 320,000,000

Total Depreciation Expense

55,650,000 508,800,000 959,300,000 1,012,633,333 1,065,966,667 1,119,300,000 1,146,133,333 775,466,667 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 349,150,000 320,000,000 320,000,000 320,000,000 320,000,000

























Interest Income (Expense)






















Senior Debt Interest

(12,500,000) (37,500,000) (62,500,000) (70,394,257) (60,952,483) (51,038,621) (40,629,066) (29,699,033) (18,222,498) (6,172,136) - - - - - - - - - -

Subordinated Debt Interest

(20,000,000) (37,500,000) (62,500,000) (68,607,883) (55,312,279) (40,953,028) (25,445,036) (8,696,405) - - - - - - - - - - - -

Total Interest Income (Expense)

(32,500,000) (75,000,000) (125,000,000) (139,002,140) (116,264,763) (91,991,649) (66,074,102) (38,395,437) (18,222,498) (6,172,136) - - - - - - - - - -

























Total Expenses

88,150,000 1,100,466,667 2,117,633,333 2,701,635,473 2,686,231,429 2,671,531,649 2,630,798,035 2,192,792,960 1,737,670,180 1,689,607,432 1,649,094,708 1,616,333,245 1,585,064,109 1,555,205,975 1,526,682,606 1,470,272,510 1,415,058,609 1,390,127,945 1,366,271,395 1,343,433,413

Earnings Before Tax

(88,150,000) 179,533,333 314,366,667 763,964,527 606,088,571 456,172,351 340,520,765 629,959,900 943,945,037 857,927,024 771,063,025 682,816,602 599,128,245 519,776,762 444,550,994 402,399,410 363,979,714 299,958,462 239,310,692 181,869,570

























Taxes

- 37,702,000 66,017,000 160,432,551 127,278,600 95,796,194 71,509,361 132,291,579 198,228,458 180,164,675 161,923,235 143,391,486 125,816,931 109,153,120 93,355,709 84,503,876 76,435,740 62,991,277 50,255,245 38,192,610

Net Income

(88,150,000) 141,831,333 248,349,667 603,531,976 478,809,971 360,376,157 269,011,404 497,668,321 745,716,579 677,762,349 609,139,790 539,425,116 473,311,314 410,623,642 351,195,285 317,895,534 287,543,974 236,967,185 189,055,447 143,676,960

























Excess Cash (available for distributions)

- - - - 4,656,144,563 663,325,771 564,016,330 384,823,622 571,622,222 620,791,986 675,192,801 605,078,984 538,585,343 475,536,266 415,764,099 352,987,333 293,174,782 242,302,290 194,109,428 148,463,720

Addition to Retained Earnings

(88,150,000) 141,831,333 248,349,667 603,531,976 (4,177,334,592) (302,949,614) (295,004,926) 112,844,699 174,094,357 56,970,363 (66,053,011) (65,653,869) (65,274,030) (64,912,624) (64,568,814) (35,091,799) (5,630,808) (5,335,104) (5,053,981) (4,786,760)

Sheet 9: CashFlow

Cash Flow Statement





















Model output summarizing a cash flow statement for the project













































Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20















































Operating Cash Flow





















Net Earnings
(88,150,000) 141,831,333 248,349,667 603,531,976 478,809,971 360,376,157 269,011,404 497,668,321 745,716,579 677,762,349 609,139,790 539,425,116 473,311,314 410,623,642 351,195,285 317,895,534 287,543,974 236,967,185 189,055,447 143,676,960

+Depreciation & Amortization
55,650,000 508,800,000 959,300,000 1,012,633,333 1,065,966,667 1,119,300,000 1,146,133,333 775,466,667 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 378,300,000 349,150,000 320,000,000 320,000,000 320,000,000 320,000,000

Change in Receivables
- (106,666,667) (96,000,000) (86,133,333) 14,440,000 13,718,000 13,032,100 12,380,495 11,761,470 11,173,397 10,614,727 10,083,991 9,579,791 9,100,801 8,645,761 8,213,473 7,802,800 7,412,660 7,042,027 6,689,925

Change in Inventory
- - - - - - - - - - - - - - - - - - - -

Change in Payables/Other Curr. Liabilities
- 43,055,556 43,055,556 43,055,556 (3,833,333) (3,646,667) (3,470,783) (3,304,979) (3,148,598) (3,001,032) (2,861,716) (2,730,122) (2,605,761) (2,488,178) (2,376,947) (2,271,675) (2,171,992) (2,077,555) (1,988,046) (1,903,165)

Cash from Operations
(32,500,000) 587,020,222 1,154,705,222 1,573,087,532 1,555,383,304 1,489,747,491 1,424,706,054 1,282,210,504 1,132,629,452 1,064,234,713 995,192,801 925,078,984 858,585,343 795,536,266 735,764,099 672,987,333 613,174,782 562,302,290 514,109,428 468,463,720
























Investing Cash Flow





















Land
(100,000,000) - - - - - - - - - - - - - - - - - - -

Construction
(550,000,000) (550,000,000) - - - - - - - - - - - - - - - - - -

Equipment
- (3,000,000,000) (3,000,000,000) - - - - - - - - - - - - - - - - -

Administrative Expenses directly attributable to facility construction
(25,000,000) (25,000,000) (50,000,000) - - - - - - - - - - - - - - - - -

Infrastructure Improvements
(25,000,000) (25,000,000) (50,000,000) - - - - - - - - - - - - - - - - -

Other Capital Investment
(150,000,000) (150,000,000) (300,000,000) - - - - - - - - - - - - - - - - -

Ongoing annual capital investment (after facility initiates operation)
- - - (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000)

Investments in Property & Equipment
(850,000,000) (3,750,000,000) (3,400,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000)

Investment tax credit
153,750,000 768,750,000 697,000,000 - - - - - - - - - - - - - - - - -

Cash from Investing
(696,250,000) (2,981,250,000) (2,703,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000) (320,000,000)
























Financing Cash Flow





















Equity Inflow (Outflow)
1,666,666,667 1,666,666,667 1,666,666,667 - - - - - - - - - - - - - - - - -

Draw (repayment) CHIPS loans
500,000,000 500,000,000 500,000,000 (184,229,728) (193,441,214) (203,113,275) (213,268,938) (223,932,385) (235,129,005) (246,885,455) - - - - - - - - - -

Draw (repayment) Non-CHIPS loans
500,000,000 500,000,000 500,000,000 (255,684,682) (276,139,456) (298,230,613) (322,089,062) (347,856,187) - - - - - - - - - - - -

Equity Payouts
- - - - (4,656,144,563) (663,325,771) (564,016,330) (384,823,622) (571,622,222) (620,791,986) (675,192,801) (605,078,984) (538,585,343) (475,536,266) (415,764,099) (352,987,333) (293,174,782) (242,302,290) (194,109,428) (148,463,720)

Cash from Financing
2,666,666,667 2,666,666,667 2,666,666,667 (439,914,410) (5,125,725,233) (1,164,669,659) (1,099,374,331) (956,612,194) (806,751,227) (867,677,441) (675,192,801) (605,078,984) (538,585,343) (475,536,266) (415,764,099) (352,987,333) (293,174,782) (242,302,290) (194,109,428) (148,463,720)
























Beginning Cash Balance
- 1,937,916,667 2,210,353,556 3,236,610,581 4,045,177,960 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000

Net Increase (decrease) in Cash
1,937,916,667 272,436,889 1,118,371,889 813,173,122 (3,890,341,929) 5,077,832 5,331,723 5,598,310 5,878,225 (123,442,727) - - - - - - - - - -

Cash (to)/from debt reserve
- - (92,114,864) (4,605,743) (4,836,030) (5,077,832) (5,331,723) (5,598,310) (5,878,225) 123,442,727 - - - - - - - - - -

Ending Cash Balance
1,937,916,667 2,210,353,556 3,236,610,581 4,045,177,960 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000
























Debt Service Coverage












































Total Debt Service Coverage





















Net Cash Flow
1,937,916,667 272,436,889 1,118,371,889 813,173,122 (3,890,341,929) 5,077,832 5,331,723 5,598,310 5,878,225 (123,442,727) - - - - - - - - - -

+Interest & Fee Expense
32,500,000 75,000,000 125,000,000 139,002,140 116,264,763 91,991,649 66,074,102 38,395,437 18,222,498 6,172,136 - - - - - - - - - -

+Principal Repayment
- - - 439,914,410 469,580,670 501,343,888 535,358,000 571,788,572 235,129,005 246,885,455 - - - - - - - - - -

+Equity Payouts
- - - - 4,656,144,563 663,325,771 564,016,330 384,823,622 571,622,222 620,791,986 675,192,801 605,078,984 538,585,343 475,536,266 415,764,099 352,987,333 293,174,782 242,302,290 194,109,428 148,463,720

Total CADS
1,970,416,667 347,436,889 1,243,371,889 1,392,089,672 1,351,648,067 1,261,739,140 1,170,780,156 1,000,605,941 830,851,950 750,406,850 675,192,801 605,078,984 538,585,343 475,536,266 415,764,099 352,987,333 293,174,782 242,302,290 194,109,428 148,463,720
























Interest & Fee Expense
32,500,000 75,000,000 125,000,000 139,002,140 116,264,763 91,991,649 66,074,102 38,395,437 18,222,498 6,172,136 - - - - - - - - - -

Principal Repayment
- - - 439,914,410 469,580,670 501,343,888 535,358,000 571,788,572 235,129,005 246,885,455 - - - - - - - - - -

Total Debt Service
32,500,000 75,000,000 125,000,000 578,916,549 585,845,433 593,335,536 601,432,102 610,184,010 253,351,503 253,057,591 - - - - - - - - - -























Total CADS/Total Debt Service
61 5 10 2 2 2 2 2 3 3 N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
























Average Debt Service Coverage
9










































Cash Flow to Equity












































Equity Investment
(1,666,666,667) (1,666,666,667) (1,666,666,667) - - - - - - - - - - - - - - - - -

Equity Payouts
- - - - 4,656,144,563 663,325,771 564,016,330 384,823,622 571,622,222 620,791,986 675,192,801 605,078,984 538,585,343 475,536,266 415,764,099 352,987,333 293,174,782 242,302,290 194,109,428 148,463,720

Net Cash Flow to Equity
(1,666,666,667) (1,666,666,667) (1,666,666,667) - 4,656,144,563 663,325,771 564,016,330 384,823,622 571,622,222 620,791,986 675,192,801 605,078,984 538,585,343 475,536,266 415,764,099 352,987,333 293,174,782 242,302,290 194,109,428 148,463,720

Sheet 10: Balance Sheet

Balance Sheet





















Model output summarizing a balance sheet for the project













































Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20















































Assets











































Current Assets





















Cash
1,937,916,667 2,210,353,556 3,236,610,581 4,045,177,960 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000 150,000,000

Debt Service Reserve/Restricted Cash
- - 92,114,864 96,720,607 101,556,637 106,634,469 111,966,193 117,564,502 123,442,727 - - - - - - - - - - -

Accounts Receivable
- 106,666,667 202,666,667 288,800,000 274,360,000 260,642,000 247,609,900 235,229,405 223,467,935 212,294,538 201,679,811 191,595,821 182,016,030 172,915,228 164,269,467 156,055,993 148,253,194 140,840,534 133,798,507 127,108,582

Inventory
- - - - - - - - - - - - - - - - - - - -

Total Current Assets
1,937,916,667 2,317,020,222 3,531,392,111 4,430,698,567 525,916,637 517,276,469 509,576,093 502,793,907 496,910,662 362,294,538 351,679,811 341,595,821 332,016,030 322,915,228 314,269,467 306,055,993 298,253,194 290,840,534 283,798,507 277,108,582
























Non-Current Assets





















Land
100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000

Construction
550,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000 1,100,000,000

Equipment
- 3,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000 6,000,000,000

Administrative Expenses directly attributable to facility construction
25,000,000 50,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000

Infrastructure Improvements
25,000,000 50,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000

Other Capital Investment
150,000,000 300,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000 600,000,000

Ongoing annual capital investment (after facility initiates operation)
- - - 320,000,000 640,000,000 960,000,000 1,280,000,000 1,600,000,000 1,920,000,000 2,240,000,000 2,560,000,000 2,880,000,000 3,200,000,000 3,520,000,000 3,840,000,000 4,160,000,000 4,480,000,000 4,800,000,000 5,120,000,000 5,440,000,000

Accumulated reduction in asset value due to ITC
(153,750,000) (922,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000) (1,619,500,000)

Accumulated Depreciation
(55,650,000) (564,450,000) (1,523,750,000) (2,536,383,333) (3,602,350,000) (4,721,650,000) (5,867,783,333) (6,643,250,000) (7,021,550,000) (7,399,850,000) (7,778,150,000) (8,156,450,000) (8,534,750,000) (8,913,050,000) (9,291,350,000) (9,640,500,000) (9,960,500,000) (10,280,500,000) (10,600,500,000) (10,920,500,000)

Total Non-Current Assets
640,600,000 3,113,050,000 4,856,750,000 4,164,116,667 3,418,150,000 2,618,850,000 1,792,716,667 1,337,250,000 1,278,950,000 1,220,650,000 1,162,350,000 1,104,050,000 1,045,750,000 987,450,000 929,150,000 900,000,000 900,000,000 900,000,000 900,000,000 900,000,000
























Total Assets
2,578,516,667 5,430,070,222 8,388,142,111 8,594,815,233 3,944,066,637 3,136,126,469 2,302,292,759 1,840,043,907 1,775,860,662 1,582,944,538 1,514,029,811 1,445,645,821 1,377,766,030 1,310,365,228 1,243,419,467 1,206,055,993 1,198,253,194 1,190,840,534 1,183,798,507 1,177,108,582















































Liabilities and Net Worth












































Current Liabilities





















Accounts Payable
- 43,055,556 86,111,111 129,166,667 125,333,333 121,686,667 118,215,883 114,910,905 111,762,307 108,761,275 105,899,559 103,169,437 100,563,676 98,075,498 95,698,551 93,426,876 91,254,884 89,177,329 87,189,283 85,286,118

Current Portion -- Long Term Debt
- - 439,914,410 469,580,670 501,343,888 535,358,000 571,788,572 235,129,005 246,885,455 - - - - - - - - - - -

Total Current Liabilities
- 43,055,556 526,025,521 598,747,337 626,677,221 657,044,667 690,004,456 350,039,909 358,647,762 108,761,275 105,899,559 103,169,437 100,563,676 98,075,498 95,698,551 93,426,876 91,254,884 89,177,329 87,189,283 85,286,118
























Non-Current Liabilities





















Long Term Debt-Senior
1,000,000,000 2,000,000,000 2,560,085,590 2,090,504,920 1,589,161,032 1,053,803,032 482,014,460 246,885,455 0 - - - - - - - - - - -

Total Non-Current Liabilities
1,000,000,000 2,000,000,000 2,560,085,590 2,090,504,920 1,589,161,032 1,053,803,032 482,014,460 246,885,455 0 - - - - - - - - - - -
























Net Worth/Stockholders Equity





















Stock and Paid in Capital
1,666,666,667 3,333,333,333 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000 5,000,000,000

Retained Earnings
(88,150,000) 53,681,333 302,031,000 905,562,976 (3,271,771,616) (3,574,721,230) (3,869,726,156) (3,756,881,457) (3,582,787,100) (3,525,816,737) (3,591,869,748) (3,657,523,616) (3,722,797,646) (3,787,710,270) (3,852,279,084) (3,887,370,882) (3,893,001,690) (3,898,336,795) (3,903,390,776) (3,908,177,536)

Total Net Worth
1,578,516,667 3,387,014,667 5,302,031,000 5,905,562,976 1,728,228,384 1,425,278,770 1,130,273,844 1,243,118,543 1,417,212,900 1,474,183,263 1,408,130,252 1,342,476,384 1,277,202,354 1,212,289,730 1,147,720,916 1,112,629,118 1,106,998,310 1,101,663,205 1,096,609,224 1,091,822,464
























Total Liabilites and Net Worth
2,578,516,667 5,430,070,222 8,388,142,111 8,594,815,233 3,944,066,637 3,136,126,469 2,302,292,759 1,840,043,907 1,775,860,662 1,582,944,538 1,514,029,811 1,445,645,821 1,377,766,030 1,310,365,228 1,243,419,467 1,206,055,993 1,198,253,194 1,190,840,534 1,183,798,507 1,177,108,582















































Reconciliation
- - - - - - - - - - - - - - - - - - - -

Sheet 11: Other >>

Processing >>
See the following tabs (Drop-Downs) directly following this tab

Sheet 12: Drop-Downs

Drop-Downs
Helper worksheet to define options in tool’s drop downs



Loan type

Amortizing

Bullet
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy