rentas

2
Edson Velásquez 20112025091 Jenny Cuéllar 20121025050 Costos ingresos IPC 0.0366 mantenimiento $1,640,195 0.0247 productividad 15 cosecha $ 775,170 0.0405 precio ### 0.0247 otos $ 770,092 0.0405 indirectos $ 452,905 0.0555 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 mantenimiento $ 1,680,708 $ 1,722,221 $ 1,764,760 $ 1,808,350 $ 1,853,016 $ 1,898,785 $ 1,945,685 $ 1,993,744 $ 2,042,989 $ 2,093,451 $ 2,145,159 $ 2,198,145 cosecha $ 806,564 $ 839,230 $ 873,219 $ 908,584 $ 945,382 $ 983,670 $ 1,023,509 $ 1,064,961 $ 1,108,092 $ 1,152,969 $ 1,199,665 $ 1,248,251 otos $ 801,281 $ 833,733 $ 867,499 $ 902,632 $ 939,189 $ 977,226 $ 1,016,804 $ 1,057,984 $ 1,100,833 $ 1,145,417 $ 1,191,806 $ 1,240,074 indirectos ### ### ### ### ### ### ### ### ### ### ### ### TOTAL COSTOS $ 3,759,801 $ 3,885,517 $ 4,015,670 $ 4,150,421 $ 4,289,941 $ 4,434,406 $ 4,583,999 $ 4,738,909 $ 4,899,334 $ 5,065,477 $ 5,237,553 $ 5,415,780 PRESENTE COSTOS $ 3,627,051 $ 3,498,988 $ 3,375,446 $ 3,256,267 $ 3,141,295 $ 3,030,383 $ 2,923,387 $ 2,820,169 $ 2,720,595 $ 2,624,537 $ 2,531,871 $ 2,442,476 TOTAL COSTOS PRESENTE $ 42,814,538 precio $ 5,044,598 $ 5,169,200 $ 5,296,879 $ 5,427,712 $ 5,561,776 $ 5,699,152 $ 5,839,921 $ 5,984,167 $ 6,131,976 $ 6,283,436 $ 6,438,637 $ 6,597,671 PRESENTE INGRESOS $ 4,866,485 $ 4,694,660 $ 4,528,902 $ 4,368,997 $ 4,214,738 $ 4,065,925 $ 3,922,366 $ 3,783,876 $ 3,650,276 $ 3,521,393 $ 3,397,061 $ 3,277,118 TOTAL INGRESOS PRESENTE $ 57,445,104 UTILIDAD $ 1,284,798 $ 1,283,682 $ 1,281,209 $ 1,277,291 $ 1,271,835 $ 1,264,746 $ 1,255,922 $ 1,245,258 $ 1,232,643 $ 1,217,959 $ 1,201,084 $ 1,181,891 VALOR PRESENTE UTILIDAD $ 1,239,434 $ 1,238,358 $ 1,235,973 $ 1,232,192 $ 1,226,929 $ 1,220,091 $ 1,211,579 $ 1,201,291 $ 1,189,121 $ 1,174,955 $ 1,158,677 $ 1,140,161 UTILIDAD TOTAL ### RENTA (2015) ###

Upload: jenny-andrea-cuellar-roncancio

Post on 07-Nov-2015

18 views

Category:

Documents


0 download

DESCRIPTION

avalúo

TRANSCRIPT

Hoja123456789101112131415Edson Velsquez 20112025091Jenny Cullar20121025050CostosingresosIPC0.0366mantenimiento$1,640,1950.0247productividad15cosecha$775,1700.0405precio$4,923,0000.0247otos$770,0920.0405indirectos$452,9050.0555

201620172018201920202021202220232024202520262027202820292030mantenimiento$1,680,708$1,722,221$1,764,760$1,808,350$1,853,016$1,898,785$1,945,685$1,993,744$2,042,989$2,093,451$2,145,159$2,198,145$2,252,439$2,308,074$2,365,084cosecha$806,564$839,230$873,219$908,584$945,382$983,670$1,023,509$1,064,961$1,108,092$1,152,969$1,199,665$1,248,251$1,298,805$1,351,407$1,406,139otos$801,281$833,733$867,499$902,632$939,189$977,226$1,016,804$1,057,984$1,100,833$1,145,417$1,191,806$1,240,074$1,290,297$1,342,554$1,396,928indirectos$471,248$490,333$510,192$530,854$552,354$574,724$598,001$622,220$647,420$673,640$700,923$729,310$758,847$789,580$821,558TOTAL COSTOS$3,759,801$3,885,517$4,015,670$4,150,421$4,289,941$4,434,406$4,583,999$4,738,909$4,899,334$5,065,477$5,237,553$5,415,780$5,600,388$5,791,616$5,989,709PRESENTE COSTOS$3,627,051$3,498,988$3,375,446$3,256,267$3,141,295$3,030,383$2,923,387$2,820,169$2,720,595$2,624,537$2,531,871$2,442,476$2,356,238$2,273,045$2,192,788TOTAL COSTOS PRESENTE$42,814,538precio$5,044,598$5,169,200$5,296,879$5,427,712$5,561,776$5,699,152$5,839,921$5,984,167$6,131,976$6,283,436$6,438,637$6,597,671$6,760,634$6,927,621$7,098,734PRESENTE INGRESOS$4,866,485$4,694,660$4,528,902$4,368,997$4,214,738$4,065,925$3,922,366$3,783,876$3,650,276$3,521,393$3,397,061$3,277,118$3,161,411$3,049,788$2,942,107TOTAL INGRESOS PRESENTE$57,445,104UTILIDAD$1,284,798$1,283,682$1,281,209$1,277,291$1,271,835$1,264,746$1,255,922$1,245,258$1,232,643$1,217,959$1,201,084$1,181,891$1,160,245$1,136,006$1,109,025VALOR PRESENTE UTILIDAD$1,239,434$1,238,358$1,235,973$1,232,192$1,226,929$1,220,091$1,211,579$1,201,291$1,189,121$1,174,955$1,158,677$1,140,161$1,119,280$1,095,896$1,069,868UTILIDAD TOTAL$17,753,805RENTA (2015)$10,349,113

Hoja2

Hoja3