Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all hand calculations in explanation. Thank You! A. INPUT DATA VARIABLE AND DISTRIBUTION TYPE initial investment uniformannual profit -triangulat salvage value-tr $67,500.00 $85,000.00

Please show all hand calculations in explanation. Thank You! image text in transcribed
A. INPUT DATA VARIABLE AND DISTRIBUTION TYPE initial investment uniformannual profit -triangulat salvage value-tr $67,500.00 $85,000.00 60,000.0O $75,000.00 $83,000.00 S Maxi 000.00 CALCULATION OF MOST LIKELY VALUES- MEAN $69,166.67 5250,000.00 $73,333.33 10 ESIRANGEAPPROACH-CHANGINGALL VARIABLES SMU TANEOUSLn Most Optimistic CF Most likely CF 12 CF pv at 15% PV at 15% PV at 15% ($200,000.00)| (S200,000.01 ($250,000.001(S2so,000 00)$300,000 001 (S300 000.00 $85,000.00 73,3130469,166.67 0,14493 55,00000$47,826.09 $85,000.00 $64.27221 ,166.57 $52,299.94 55,000.00$41,587.90 13 15 16 17 s8s,000.00$55,888.88$69,166.67 $45,478.21 $55,000.00 $36,163.39 $85,000.00 03 $6,166.6739,54627 $55,000.00 $31,446.43 $85,000.00$42,260.02$69,166.67 $34,388.06 $55,000.00 $27,344.72 s85,000.00 36,74786,166.67 S29,902.66 $$5,000.00 $23,778.02 $170,000.00 $63,909.30 $142,500.00 $53,57103 $115,000.00 $43,232.76 19 20 21 IRR/NPV 40.10%| s185,S90.33 22.62%| $65,331.08 620. #11 and #12 refer to the above table. 11. Show the work using financial notations (P/F, 196, n) to calculate the value in Row 15 Column E. Show the logic first and then replace the logic with values from the interest tables. 12. Show the work to calculate the values in the cell number identified below. (Please use actual numerical values instead of cell values i.e. Do not use row or columns numbers in your response) a. Row 14 Column C: b. Row 14 Column D: c. Row 14 Column E: d. Row 20 Column B: e. Row 20 Column D: f. Row 20 Column F

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

School Finance A Policy Perspective

Authors: Allan Odden, Lawrence Picus

6th Edition

1259922316, 9781259922312

More Books

Students also viewed these Finance questions

Question

What opportunities exist for raises and advancement?

Answered: 1 week ago

Question

Understand links between the university business model and HRM.

Answered: 1 week ago