Please solve as soon as possible, project is due on saturday morning!!
EXERCISE IN CLASS EVALUATE THE PROJECT FOR THE CREATION OF AN ASSISTED REPRODUCTION UNIT WITH THE DATA OF INVESTMENT, COSTS AND INCOME DELIVERED IN THE FOLLOWING SHEETS ASSUME THE RISK-FREE RATE IS 7% AND THE RISK PREMIUM YOU WANT FOR THE PROJECT IS 10% ASSUMPTIONS: 1) INCOME GROWS BY 7% EVERY YEAR, FROM THE SECOND YEAR 2) COSTS GROW BY 3% EVERY YEAR FROM THE 2ND YEAR 3) THE EVALUATION PERIOD IS 10 YEARS INDICATE THE VAN, TIR AND PAYBACK FOR THE LEASE AND PURCHASE OPTIONS ASSISTED REPRODUCTION UNIT PROJECT: INVERSION INICIAL INFRAESTRUCTURA, MOBILIARIO, INSTRUMENTAL Y EQUIPOS DESCRIPTION RENT $ $ $ 7.000,00 $ 12.500,00 $ 3.400,00 $ 750,00 $ 2.300,00 $ $ $ $ 65.500,00 $ $ 40.000,00 $ $ 1.952,00 $ $ 1.754,00 $ $ 1.980,00 $ $ 20.000,00 $ $ 3.600,00 $ $ 74.500,00 $ $ 6.690,00 $ $ 3.500,00 $ $ 2.100,00 $ $ 1.900,00 $ $ 750,00 $ $ 400,00 $ $ 2.550,00 $ $ 253.126,00 $ OFFICES (LOCAL HOSPITAL MAESTRIA) LOCAL ADEQUATIONS FURNITURE COMPUTER EQUIPMENT AND PRINTERS TELEPHONES AND FAXES MIKOBA BIOLOGICAL MICROSCOPE MIKOBA INVERTED MICROSCOPE PENGUIN CO2 INCUBATOR 30 L THERMAL STATION THERMAL STAGE FOR MICROSCOPE THERMAL TUBE HOLDER LAMINAR FLOW CHAMBER AVE ECHOGRAPH CENTRIFUGE N2 TANK FOR SEMEN PRESERVATION SHAYLON GOOSENECKLAMPS TENSIOMETERS AND STETHOSCOPES DIAGNOSTIC SETS STAINLESS STEEL CURING TABLE TOTAL INVERSION BUY 7.000,00 12.500,00 3.400,00 750,00 2.300,00 65.500,00 40.000,00 1.952,00 1.754,00 1.980,00 20.000,00 3.600,00 74.500,00 6.690,00 3.500,00 2.100,00 1.900,00 750,00 400,00 2.550,00 253.126,00 PROJECT ASSUMPTIONS NUMBER OF M2 REQUIRED VALUE PER M2 MONTHLY LOCAL RENTAL VALUE NUMBER OF MONTHS PER YEAR $ $ 150 1.900,00 650,00 12 ASSISTED REPRODUCTION UNIT PROJECT: DESCRIPTION MONTHLY VALUE MEDICAL FEES $ $ NURSE SECRETARY $ SUPPLIES $ RENT OFFICE $ ELECTRICITY, WATER, TELEPHONE, INTERNET, DIRECTV $ ALIQUOT $ STATIONERY $ MARKETING $ 3.500,00 $ 800,00 $ 460,00 $ 400,00 $ 1.000,00 $ 475,00 $ 220,00 $ 175,00 $ 500,00 $ ANNUAL VALUE 42.000,00 9.600,00 5.520,00 4.800,00 12.000,00 5.700,00 2.640,00 2.100,00 6.000,00 REVENUE ANALYSIS BY ITEM INCOME DESCRIPTION PATIENTS X MONTH CONSULTATION PRICE X GYNECOLOGICAL CONSULTATION TOTAL GYNECOLOGICAL CONSULTATION PATIENTS X MONTH COLPOSCOPY PRICE X COLPOSCOPY TOTAL COLPOSCOPIES PATIENTS X MONTH MONITORING PRICE X MONITORING TOTAL MONITORING PATIENTS X MONTH ULTRASOUND PRICE X ULTRASOUND TOTAL ULTRASOUND PATIENTS X MONTH MAMMOGRAPHY PRICE X MAMMOGRAPHY TOTAL MAMMOGRAPHY PATIENTS X MONTH BONE DENSITOMETRY PRICES X BONE DENSITOMETRY TOTAL BONE DENSITOMETRY PATIENTS X MONTH FAMILY PLANNING PRICE X FAMILY PLANNING TOTAL FAMILY PLANNING PATIENTS X ARTIFICIAL INSEMINATION PRICE X ARTIFICIAL INSEMINATION TOTAL ARTIFICIAL INSEMINATION TOTAL INCOME X MONTH JAN 2021 600 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 feb.-21 602 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 mar.-21 604 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 APR 2021 606 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 may.-21 608 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 jun.-21 610 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 jul.-21 612 30 60 20 60 5 20 10 20 10 20 5 | 20 15 3 2.500 AUG 2021 614 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 sep.-21 616 30 60 20 60 5 20 10 20 10 20 5 20 | 15 3 2.500 oct.-21 618 30 60 20 60 5 20 10 | 20 10 20 5 |20] 15 3 2.500 nov.-21 620 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 DEC 2021 622 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 TOTAL EXERCISE IN CLASS EVALUATE THE PROJECT FOR THE CREATION OF AN ASSISTED REPRODUCTION UNIT WITH THE DATA OF INVESTMENT, COSTS AND INCOME DELIVERED IN THE FOLLOWING SHEETS ASSUME THE RISK-FREE RATE IS 7% AND THE RISK PREMIUM YOU WANT FOR THE PROJECT IS 10% ASSUMPTIONS: 1) INCOME GROWS BY 7% EVERY YEAR, FROM THE SECOND YEAR 2) COSTS GROW BY 3% EVERY YEAR FROM THE 2ND YEAR 3) THE EVALUATION PERIOD IS 10 YEARS INDICATE THE VAN, TIR AND PAYBACK FOR THE LEASE AND PURCHASE OPTIONS ASSISTED REPRODUCTION UNIT PROJECT: INVERSION INICIAL INFRAESTRUCTURA, MOBILIARIO, INSTRUMENTAL Y EQUIPOS DESCRIPTION RENT $ $ $ 7.000,00 $ 12.500,00 $ 3.400,00 $ 750,00 $ 2.300,00 $ $ $ $ 65.500,00 $ $ 40.000,00 $ $ 1.952,00 $ $ 1.754,00 $ $ 1.980,00 $ $ 20.000,00 $ $ 3.600,00 $ $ 74.500,00 $ $ 6.690,00 $ $ 3.500,00 $ $ 2.100,00 $ $ 1.900,00 $ $ 750,00 $ $ 400,00 $ $ 2.550,00 $ $ 253.126,00 $ OFFICES (LOCAL HOSPITAL MAESTRIA) LOCAL ADEQUATIONS FURNITURE COMPUTER EQUIPMENT AND PRINTERS TELEPHONES AND FAXES MIKOBA BIOLOGICAL MICROSCOPE MIKOBA INVERTED MICROSCOPE PENGUIN CO2 INCUBATOR 30 L THERMAL STATION THERMAL STAGE FOR MICROSCOPE THERMAL TUBE HOLDER LAMINAR FLOW CHAMBER AVE ECHOGRAPH CENTRIFUGE N2 TANK FOR SEMEN PRESERVATION SHAYLON GOOSENECKLAMPS TENSIOMETERS AND STETHOSCOPES DIAGNOSTIC SETS STAINLESS STEEL CURING TABLE TOTAL INVERSION BUY 7.000,00 12.500,00 3.400,00 750,00 2.300,00 65.500,00 40.000,00 1.952,00 1.754,00 1.980,00 20.000,00 3.600,00 74.500,00 6.690,00 3.500,00 2.100,00 1.900,00 750,00 400,00 2.550,00 253.126,00 PROJECT ASSUMPTIONS NUMBER OF M2 REQUIRED VALUE PER M2 MONTHLY LOCAL RENTAL VALUE NUMBER OF MONTHS PER YEAR $ $ 150 1.900,00 650,00 12 ASSISTED REPRODUCTION UNIT PROJECT: DESCRIPTION MONTHLY VALUE MEDICAL FEES $ $ NURSE SECRETARY $ SUPPLIES $ RENT OFFICE $ ELECTRICITY, WATER, TELEPHONE, INTERNET, DIRECTV $ ALIQUOT $ STATIONERY $ MARKETING $ 3.500,00 $ 800,00 $ 460,00 $ 400,00 $ 1.000,00 $ 475,00 $ 220,00 $ 175,00 $ 500,00 $ ANNUAL VALUE 42.000,00 9.600,00 5.520,00 4.800,00 12.000,00 5.700,00 2.640,00 2.100,00 6.000,00 REVENUE ANALYSIS BY ITEM INCOME DESCRIPTION PATIENTS X MONTH CONSULTATION PRICE X GYNECOLOGICAL CONSULTATION TOTAL GYNECOLOGICAL CONSULTATION PATIENTS X MONTH COLPOSCOPY PRICE X COLPOSCOPY TOTAL COLPOSCOPIES PATIENTS X MONTH MONITORING PRICE X MONITORING TOTAL MONITORING PATIENTS X MONTH ULTRASOUND PRICE X ULTRASOUND TOTAL ULTRASOUND PATIENTS X MONTH MAMMOGRAPHY PRICE X MAMMOGRAPHY TOTAL MAMMOGRAPHY PATIENTS X MONTH BONE DENSITOMETRY PRICES X BONE DENSITOMETRY TOTAL BONE DENSITOMETRY PATIENTS X MONTH FAMILY PLANNING PRICE X FAMILY PLANNING TOTAL FAMILY PLANNING PATIENTS X ARTIFICIAL INSEMINATION PRICE X ARTIFICIAL INSEMINATION TOTAL ARTIFICIAL INSEMINATION TOTAL INCOME X MONTH JAN 2021 600 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 feb.-21 602 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 mar.-21 604 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 APR 2021 606 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 may.-21 608 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 jun.-21 610 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 jul.-21 612 30 60 20 60 5 20 10 20 10 20 5 | 20 15 3 2.500 AUG 2021 614 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 sep.-21 616 30 60 20 60 5 20 10 20 10 20 5 20 | 15 3 2.500 oct.-21 618 30 60 20 60 5 20 10 | 20 10 20 5 |20] 15 3 2.500 nov.-21 620 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 DEC 2021 622 30 60 20 60 5 20 10 20 10 20 5 20 15 3 2.500 TOTAL
