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
SiteLock