#### Details of this Paper

##### Without Loan

Description

solution

Question

Without Loan;0;Sales;COGS;Gross Margin;Administrative Expense;Depreciation;Total Fixed Expenses;Earning before Taxes;Taxes;Net Income;Depreciation (+);Operating Cash Flow;Working Capital;Salvage Value;Cash Flow;-\$500.00;-\$2,700.00;\$0.00;-\$3,200.00;IRR=;NPV=;1;\$10,000.00;\$6,200.00;\$3,800.00;\$2,400.00;\$100.00;\$2,500.00;\$1,300.00;\$390.00;\$910.00;\$100.00;\$1,010.00;-\$270.00;\$0.00;\$740.00;29.95%;\$1,974.67;2;\$11,000.00;\$6,820.00;\$4,180.00;\$2,640.00;\$100.00;\$2,740.00;\$1,440.00;\$432.00;\$1,008.00;\$100.00;\$1,108.00;-\$540.00;\$0.00;\$568.00;3;\$13,000.00;\$8,060.00;\$4,940.00;\$3,120.00;\$100.00;\$3,220.00;\$1,720.00;\$516.00;\$1,204.00;\$100.00;\$1,304.00;\$1,080.00;\$0.00;\$2,384.00;4;\$9,000.00;\$5,580.00;\$3,420.00;\$2,160.00;\$100.00;\$2,260.00;\$1,160.00;\$348.00;\$812.00;\$100.00;\$912.00;\$810.00;\$0.00;\$1,722.00;5;\$6,000.00;\$3,720.00;\$2,280.00;\$1,440.00;\$100.00;\$1,540.00;\$740.00;\$222.00;\$518.00;\$100.00;\$618.00;\$1,620.00;\$0.00;\$2,238.00;With Loan (25%);Devaluation=;Debt Rate=;0;12%;0;Sales;COGS;Gross Margin;Administrative Expense;Depreciation;Interest;Total Fixed Expenses;Earning before Taxes;Taxes;Net Income;Depreciation (+);Operating Cash Flow;Working Capital;Loan/Principal Payment;Salvage Value;Cash Flow;-\$500.00;-\$500.00;-\$2,700.00;\$800.00;\$0.00;-\$2,400.00;1;\$10,000.00;\$6,200.00;\$3,800.00;\$2,400.00;\$100.00;\$96.00;\$2,596.00;\$1,204.00;\$361.20;\$842.80;\$100.00;\$942.80;-\$270.00;-\$160.00;\$0.00;\$512.80;Inflation=;Req Rate=;2;\$11,000.00;\$6,820.00;\$4,180.00;\$2,640.00;\$100.00;\$76.80;\$2,816.80;\$1,363.20;\$408.96;\$954.24;\$100.00;\$1,054.24;-\$540.00;-\$160.00;\$0.00;\$354.24;IRR=;NPV=;Period;0;1;2;3;4;5;Beginning;Balance;\$800.00;\$800.00;\$640.00;\$480.00;\$320.00;\$160.00;Principal;\$0.00;-\$160.00;-\$160.00;-\$160.00;-\$160.00;-\$160.00;3;\$13,000.00;\$8,060.00;\$4,940.00;\$3,120.00;\$100.00;\$57.60;\$3,277.60;\$1,662.40;\$498.72;\$1,163.68;\$100.00;\$1,263.68;\$1,080.00;-\$160.00;\$0.00;\$2,183.68;0;10;4;\$9,000.00;\$5,580.00;\$3,420.00;\$2,160.00;\$100.00;\$38.40;\$2,298.40;\$1,121.60;\$336.48;\$785.12;\$100.00;\$885.12;\$810.00;-\$160.00;\$0.00;\$1,535.12;5;\$6,000.00;\$3,720.00;\$2,280.00;\$1,440.00;\$100.00;\$19.20;\$1,559.20;\$720.80;\$216.24;\$504.56;\$100.00;\$604.56;\$1,620.00;-\$160.00;\$0.00;\$2,064.56;Interest;Total PMT;\$0.00;\$0.00;-\$96.00;-\$256.00;-\$76.80;-\$236.80;-\$57.60;-\$217.60;-\$38.40;-\$198.40;-\$19.20;-\$179.20;Ending;Balance;\$800.00;\$640.00;\$480.00;\$320.00;\$160.00;\$0.00;34.72%;\$2,041.64;With Loan (50%);Devaluation=;Debt Rate=;0;12%;0;Sales;COGS;Gross Margin;Administrative Expense;Depreciation;Interest;Total Fixed Expenses;Earning before Taxes;Taxes;Net Income;Depreciation (+);Operating Cash Flow;Working Capital;Loan/Principal Payment;Salvage Value;Cash Flow;-\$500.00;-\$500.00;-\$2,700.00;\$1,600.00;\$0.00;-\$1,600.00;1;\$10,000.00;\$6,200.00;\$3,800.00;\$2,400.00;\$100.00;\$192.00;\$2,692.00;\$1,108.00;\$332.40;\$775.60;\$100.00;\$875.60;-\$270.00;-\$320.00;\$0.00;\$285.60;Inflation=;Req Rate=;2;\$11,000.00;\$6,820.00;\$4,180.00;\$2,640.00;\$100.00;\$153.60;\$2,893.60;\$1,286.40;\$385.92;\$900.48;\$100.00;\$1,000.48;-\$540.00;-\$320.00;\$0.00;\$140.48;IRR=;NPV=;Period;0;1;2;3;4;5;Beginning;Balance;\$1,600.00;\$1,600.00;\$1,280.00;\$960.00;\$640.00;\$320.00;Principal;\$0.00;-\$320.00;-\$320.00;-\$320.00;-\$320.00;-\$320.00;3;\$13,000.00;\$8,060.00;\$4,940.00;\$3,120.00;\$100.00;\$115.20;\$3,335.20;\$1,604.80;\$481.44;\$1,123.36;\$100.00;\$1,223.36;\$1,080.00;-\$320.00;\$0.00;\$1,983.36;0;10;4;\$9,000.00;\$5,580.00;\$3,420.00;\$2,160.00;\$100.00;\$76.80;\$2,336.80;\$1,083.20;\$324.96;\$758.24;\$100.00;\$858.24;\$810.00;-\$320.00;\$0.00;\$1,348.24;5;\$6,000.00;\$3,720.00;\$2,280.00;\$1,440.00;\$100.00;\$38.40;\$1,578.40;\$701.60;\$210.48;\$491.12;\$100.00;\$591.12;\$1,620.00;-\$320.00;\$0.00;\$1,891.12;Interest;Total PMT;\$0.00;\$0.00;-\$192.00;-\$512.00;-\$153.60;-\$473.60;-\$115.20;-\$435.20;-\$76.80;-\$396.80;-\$38.40;-\$358.40;Ending;Balance;\$1,600.00;\$1,280.00;\$960.00;\$640.00;\$320.00;\$0.00;42.60%;\$2,108.61;With Loan (75%);Devaluation=;Debt Rate=;0;Sales;COGS;Gross Margin;Administrative Expense;Depreciation;Interest;Total Fixed Expenses;Earning before Taxes;Taxes;Net Income;Depreciation (+);Operating Cash Flow;Working Capital;Loan/Principal Payment;Salvage Value;Cash Flow;0;12%;1;\$10,000.00;\$6,200.00;\$3,800.00;\$2,400.00;\$100.00;\$288.00;\$2,788.00;\$1,012.00;\$303.60;\$708.40;\$100.00;\$808.40;-\$270.00;-\$480.00;\$0.00;\$58.40;-\$500.00;-\$500.00;-\$2,700.00;\$2,400.00;\$0.00;-\$800.00;Inflation=;Req Rate=;2;\$11,000.00;\$6,820.00;\$4,180.00;\$2,640.00;\$100.00;\$230.40;\$2,970.40;\$1,209.60;\$362.88;\$846.72;\$100.00;\$946.72;-\$540.00;-\$480.00;\$0.00;-\$73.28;IRR=;NPV=;Period;0;1;2;3;4;5;Beginning;Balance;\$2,400.00;\$2,400.00;\$1,920.00;\$1,440.00;\$960.00;\$480.00;Principal;\$0.00;-\$480.00;-\$480.00;-\$480.00;-\$480.00;-\$480.00;3;\$13,000.00;\$8,060.00;\$4,940.00;\$3,120.00;\$100.00;\$172.80;\$3,392.80;\$1,547.20;\$464.16;\$1,083.04;\$100.00;\$1,183.04;\$1,080.00;-\$480.00;\$0.00;\$1,783.04;0;10;4;\$9,000.00;\$5,580.00;\$3,420.00;\$2,160.00;\$100.00;\$115.20;\$2,375.20;\$1,044.80;\$313.44;\$731.36;\$100.00;\$831.36;\$810.00;-\$480.00;\$0.00;\$1,161.36;5;\$6,000.00;\$3,720.00;\$2,280.00;\$1,440.00;\$100.00;\$57.60;\$1,597.60;\$682.40;\$204.72;\$477.68;\$100.00;\$577.68;\$1,620.00;-\$480.00;\$0.00;\$1,717.68;Interest;Total PMT;\$0.00;\$0.00;-\$288.00;-\$768.00;-\$230.40;-\$710.40;-\$172.80;-\$652.80;-\$115.20;-\$595.20;-\$57.60;-\$537.60;Ending;Balance;\$2,400.00;\$1,920.00;\$1,440.00;\$960.00;\$480.00;\$0.00;59.11%;\$2,175.58

Paper#28337 | Written in 18-Jul-2015

Price : \$27