correcao monetaria (2)

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

correção_monetária
	Fluxo de caixa nominal	Taxa de inflação	Passos (nota de aula)	Fluxo de caixa real
	Ano	Receita	Despesa	Ano	Variação anual do IPCA (% a.a) [πIPCA]	Fonte	(1) e (2)	(3)	(4)	Receita real (5)	Despesa real (5)
	2010	0.0	* 252,100,653.49	2010	5.91	IPEADATA	1	1	1	0.0	* 252,100,653.49
	2011	0.0	* 2,084,573,966.49	2011	6.5	IPEADATA	1.065	1.065	0.9389671362	0.0	* 1,957,346,447.41
	2012	0.0	* 3,775,543,596.36	2012	5.84	IPEADATA	1.0584	1.127196	0.8871571581	0.0	* 3,349,500,527.29
	2013	0.0	* 3,196,332,394.47	2013	5.91	IPEADATA	1.0591	1.1938132836	0.8376519291	0.0	* 2,677,413,996.29
	2014	0.0	* 2,320,066,590.23	2014	6.41	IPEADATA	1.0641	1.2703367151	0.7871928664	0.0	* 1,826,339,869.34
	2015	* 1,138,848,828.22	* 1,126,313,344.43	2015	10.67	IPEADATA	1.1067	1.4058816426	0.7112974305	* 810,060,245.28	* 801,143,787.87
	2016	* 1,170,916,008.62	* 504,122,995.02	2016	6.29	IPEADATA	1.0629	1.4943115979	0.6692044694	* 783,582,226.27	* 337,361,361.40
	2017	* 1,204,112,146.90	* 507,609,271.77	2017	3.93	BACEN, Focus	1.0393	1.5530380437	0.6438992297	* 775,326,883.84	* 326,849,219.07
	2018	* 1,238,475,203.75	* 518,270,656.49	2018	4.34	BACEN, Focus	1.0434	1.6204398948	0.6171163788	* 764,283,333.02	* 319,833,310.79
	2019	* 1,274,043,709.75	* 536,730,216.35	2019	4.29	BACEN, Focus	1.0429	1.6899567663	0.591731114	* 753,891,303.72	* 317,599,968.86
	2020	* 1,310,857,556.07	* 541,324,119.62	2020	4.25	BACEN, Focus	1.0425	1.7617799288	0.5676077833	* 744,052,951.57	* 307,259,783.56
	2021	* 1,348,958,503.73	* 560,047,456.00	2021	4.19	BACEN, Focus	1.0419	1.8355985079	0.5447814409	* 734,887,557.36	* 305,103,460.04
	2022	* 1,388,389,686.06	* 565,235,551.77	2022	4.19	Hipótese	1.0419	1.9125100853	0.5228730597	* 725,951,563.19	* 295,546,442.40
	2023	* 1,429,196,088.23	* 584,568,660.93	2023	4.19	Hipótese	1.0419	1.9926442579	0.5018457239	* 717,235,945.43	* 293,363,282.79
	2024	* 1,471,429,849.49	* 590,368,229.75	2024	4.19	Hipótese	1.0419	2.0761360523	0.4816640022	* 708,734,790.21	* 284,359,124.29
	2025	* 1,501,299,875.43	* 617,542,063.15	2025	4.19	Hipótese	1.0419	2.1631261529	0.4622938882	* 694,041,756.84	* 285,485,921.53
	2026	* 1,531,776,262.91	* 622,040,941.86	2026	4.19	Hipótese	1.0419	2.2537611387	0.4437027433	* 679,653,329.98	* 276,001,272.35
	2027	* 1,562,871,321.04	* 633,946,455.44	2027	4.19	Hipótese	1.0419	2.3481937304	0.4258592411	* 665,563,194.72	* 269,971,956.41
	2028	* 1,594,597,608.86	* 646,057,543.23	2028	4.19	Hipótese	1.0419	2.4465830477	0.4087333152	* 651,765,167.07	* 264,065,241.45
	2029	* 1,626,967,940.32	* 658,348,463.65	2029	4.19	Hipótese	1.0419	2.5490948774	0.3922961083	* 638,253,191.25	* 258,267,540.17
	2030	* 1,659,995,389.51	* 698,399,185.43	2030	4.19	Hipótese	1.0419	2.6559019528	0.3765199235	* 625,021,337.01	* 262,961,207.85
	2031	* 1,693,693,295.92	* 719,724,638.48	2031	4.19	Hipótese	1.0419	2.7671842446	0.3613781778	* 612,063,797.06	* 260,092,778.38
	2032	* 1,728,075,269.82	* 726,635,708.35	2032	4.19	Hipótese	1.0419	2.8831292645	0.3468453573	* 599,374,884.47	* 252,030,221.92
	2033	* 1,763,155,197.80	* 748,690,404.65	2033	4.19	Hipótese	1.0419	3.0039323807	0.3328969741	* 586,949,030.26	* 249,236,770.27
	2034	* 1,798,947,248.31	* 756,052,242.09	2034	4.19	Hipótese	1.0419	3.1297971474	0.319509525	* 574,780,780.86	* 241,565,892.77
	2035	* 1,835,465,877.46	* 704,012,425.09	2035	4.19	Hipótese	1.0419	3.2609356479	0.3066604521	* 562,864,795.77	* 215,892,768.55
	2036	* 1,872,725,834.77	* 715,443,683.47	2036	4.19	Hipótese	1.0419	3.3975688515	0.2943281045	* 551,195,845.21	* 210,575,183.24
	2037	* 1,910,742,169.21	* 727,664,407.12	2037	4.19	Hipótese	1.0419	3.5399269864	0.2824917022	* 539,768,807.82	* 205,559,156.99
	2038	* 1,949,530,235.25	* 740,896,907.71	2038	4.19	Hipótese	1.0419	3.6882499271	0.2711313007	* 528,578,668.41	* 200,880,342.26
	2039	* 1,989,105,699.02	* 746,166,149.06	2039	4.19	Hipótese	1.0419	3.8427875991	0.2602277576	* 517,620,515.77	* 194,173,143.80
	2040	* 2,029,484,544.71	* 771,824,244.18	2040	4.19	Hipótese	1.0419	4.0038003995	0.2497627005	* 506,889,540.49	* 192,772,907.53
	2041	* 2,070,683,080.97	* 790,083,334.16	2041	4.19	Hipótese	1.0419	4.1715596362	0.2397184955	* 496,381,032.88	* 189,397,588.21
	2042	* 2,112,717,947.52	* 809,776,771.66	2042	4.19	Hipótese	1.0419	4.346347985	0.2300782182	* 486,090,380.89	* 186,311,996.75
	2043	* 2,155,606,121.85	* 828,905,878.00	2043	4.19	Hipótese	1.0419	4.5284599656	0.2208256245	* 476,013,068.07	* 183,043,658.18
	2044	* 2,199,364,926.12	* 842,438,953.79	2044	4.19	Hipótese	1.0419	4.7182024381	0.2119451238	* 466,144,671.61	* 178,550,828.38
Q.1
	Taxa de juro a.a [comum] (WACC)	Ano	Projeto 1	Projeto 2
	0.0646	Receita	Despesa	Receita	Despesa
	2011	0.0	* 342.80	0.0	0.0
	2012	* 842.60	* 2,501.00	0.0	* 98.90
	2013	* 950.60	* 2,513.50	* 149.40	* 98.40
	2014	* 1,027.90	* 2,559.40	* 163.10	* 988.10
	2015	* 1,124.90	* 1,837.40	* 179.40	* 984.10
	2016	* 1,229.60	* 1,857.40	* 191.10	* 983.10
	2017	* 1,320.70	* 2,291.40	* 204.50	* 988.00
	2018	* 1,320.70	* 2,291.40	* 228.40	* 755.70
	2019	* 1,320.70	* 2,291.40	* 239.70	* 755.70
	2020	* 1,507.00	* 2,394.50	* 239.70	* 755.70
	2021	* 1,507.00	* 2,394.50	* 239.70	* 755.70
	2022	* 1,507.00	* 2,394.50	* 239.70	* 755.70
	2023	* 1,507.00	* 2,394.50	* 239.70	* 1,200.10
	2024	* 1,507.00	* 2,394.50	* 239.70	* 1,200.10
	2025	* 1,521.80	* 2,421.50	* 303.20	* 1,200.10
	2026	* 1,521.80	* 2,421.50	* 303.20	* 1,200.10
	2027	* 1,521.80	* 2,421.50	* 303.20	* 1,200.10
	2028	* 1,521.80	* 2,421.50	* 303.20	* 1,208.20
	2029	* 1,521.80	* 2,421.50	* 303.20	* 1,208.20
	2030	* 1,521.80	* 2,421.50	* 303.20	* 1,208.20
	2031	* 1,493.30	* 2,452.90	* 382.20	* 1,208.20
Q.2
	Taxa de juro a.a [comum] (WACC)	Ano	Projeto 1	Projeto 2	Ano	Projeto 1	Projeto 2
	0.1	CAPEX	OPEX	RECEITA	CAPEX	OPEX	RECEITA	Receita	Despesa	Receita	Despesa
	2017	0	24170	0	0	4991	0	2017	0.0	* 24,170.00	0.0	* 4,991.00
	2018	0	23518	0	0	4452	0	2018	0.0	* 23,518.00	0.0	* 4,452.00
	2019	0	61832	0	0	4452	0	2019	0.0	* 61,832.00	0.0	* 4,452.00
	2020	0	61600	79767	0	4452	0	2020	* 79,767.00	* 61,600.00	0.0	* 4,452.00
	2021	0	62375	81796	0	39472	0	2021	* 81,796.00	* 62,375.00	0.0	* 39,472.00
	2022	0	63149	83566	0	39427	62056	2022	* 83,566.00	* 63,149.00	* 62,056.00	* 39,427.00
	2023	0	63846	85337	0	39427	62056	2023	* 85,337.00	* 63,846.00	* 62,056.00	* 39,427.00
	2024	0	64891	87107	0	41160	62056	2024	* 87,107.00	* 64,891.00	* 62,056.00	* 41,160.00
	2025	0	65975	89708	0	41437	62056	2025	* 89,708.00	* 65,975.00	* 62,056.00	* 41,437.00
	2026	0	67027	92310	0	41423	62056	2026	* 92,310.00	* 67,027.00	* 62,056.00	* 41,423.00
	2027	0	68056	94912	0	41442	62056	2027	* 94,912.00	* 68,056.00	* 62,056.00	* 41,442.00
	2028	0	71491	97513	0	41436	62056	2028	* 97,513.00	* 71,491.00	* 62,056.00	* 41,436.00
	2029	0	74868	100115	0	41409	62056	2029	* 100,115.00	* 74,868.00	* 62,056.00	* 41,409.00
	2030	0	76133	102176	0	41470	62056	2030	* 102,176.00	* 76,133.00	* 62,056.00	* 41,470.00
	2031	0	77637	104778	0	41861	62056	2031	* 104,778.00	* 77,637.00	* 62,056.00	* 41,861.00
	2032	0	79043	107379	0	41884	61935	2032	* 107,379.00	* 79,043.00	* 61,935.00	* 41,884.00
	2033	0	78713	109981	0	41653	61935	2033	* 109,981.00	* 78,713.00	* 61,935.00	* 41,653.00
	2034	0	80314	113035	0	41647	62007	2034	* 113,035.00	* 80,314.00	* 62,007.00	* 41,647.00
	2035	0	80904	116254	0	41635	62007	2035	* 116,254.00	* 80,904.00	* 62,007.00	* 41,635.00
	2036	0	80904	117534	0	41666	62007	2036	* 117,534.00	* 80,904.00	* 62,007.00	* 41,666.00
	2037	0	80924	117534	0	41633	62007	2037	* 117,534.00	* 80,924.00	* 62,007.00	* 41,633.00
	2038	0	80929	117534	0	41633	62007	2038	* 117,534.00	* 80,929.00	* 62,007.00	* 41,633.00
	2039	0	80891	117534	0	41653	62007	2039	* 117,534.00	* 80,891.00	* 62,007.00	* 41,653.00
	2040	0	80937	117534	0	41661	62007	2040	* 117,534.00	* 80,937.00	* 62,007.00	* 41,661.00
	2041	0	80904	117534	0	41620	62007	2041	* 117,534.00	* 80,904.00	* 62,007.00	* 41,620.00