If you have access to a spreadsheet package, find out whether it has a net present value
Question:
If you have access to a spreadsheet package, find out whether it has a net present value (NPV) function. If so, use the data in Table 11.3 to satisfy yourself that the spreadsheet produces answers similar to those derived here.
Table 11.3
Transcribed Image Text:
Table 11.3 Data for net present value illustration Cash flows Outlay Cash inflows, after deducting all outflows of the year: Year 1 Year 2 Year 3 Project A 120,000 60,000 60,000 60,000
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (2 reviews)
Most spreadsheet programs including Microsoft Excel and Google Sheets offer a Net Present Value NPV ...View the full answer
Answered By
Parvesh Kumar
I am an experienced Mathematics and Statistics tutor with 10 years of experience teaching students and working professionals. I love teaching students who are passionate to learn subjects or wants to understand any mathematics and statistics concept at graduation or master’s level. I have worked with thousands of students in my teaching career. I have helped students deal with difficult topics and subjects like Calculus, Algebra, Discrete Mathematics, Complex analysis, Graph theory, Hypothesis testing, Probability, Statistical Inference and more. After learning from me, students have found Mathematics and Statistics not dull but a fun subject. I can handle almost all curriculum of mathematics. I did B.Sc (mathematics), M.Sc (mathematics), M.Tech (IT) and am also Gate (CS) qualified. I have worked in various college and school and also provided online tutoring to American and Canadian students. I look forward to discussing with you and make learning a meaningful and purposeful
5.00+
4+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the...
-
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...
-
Use the data in Exercise 13.28.To familiarize yourself with recursive least squares, estimate the savings functions for 19701981, 19701985, 19701990, and 19701995. Comment on the stability of...
-
Name another factor, other than the rate of cooling, that can affect crystal size. Very coarse-grained intrusions of igneous rocks (pegmatites) are an example of this factor at work.
-
Determine the horizontal and vertical components of force at pins A and D. D 2 m 0.3 m 14 1.5 m -1.5 m E 12 kN
-
Peng Plasma Pricing. Peng Plasma is a privately held Chinese business. It specializes in the manufacture of plasma cutting torches. Over the past eight years it has held the Chinese renminbi price of...
-
The so-called Internet Bubble gripped stock markets in 1998, 1999, and 2000, as discussed in the chapter. Internet stocks traded at multiples of earnings and sales rarely seen in stock markets....
-
Lines r and s are cut by a transversal. 143 (3x+14) What value for x proves that r || s? Type your answer...
-
A company is considering investing $100,000 in a new machine that will reduce its annual cash operating costs as follows: Calculate the payback period to the nearest 0.1 years. Year 1234 Operating...
-
Use your calculator to check the discount factors for the present value of 1 at the end of one year, two years and three years for a discount rate of 10%. Write a parallel table for 8 per cent and 12...
-
The following information pertains to the payroll of Fanelli Fashion Company on June 7: a. The total wages earned by employees are $2,910. b. The state unemployment insurance contribution rate is...
-
Blue Ltd. (BL) is a retailer of office equipment. The company uses a periodic inventory system and on October 1 had 1,900 units of inventory with a total cost of $38,000. During the manth of October,...
-
VEC Inc. currently has 1450000 zero coupon bonds outstanding, each with a face value of $1,000. The bonds have a maturity of 4 years and they are traded in the market at 87% of par. If the tax rate...
-
A multinational company is currently producing goods in China to export to the US,WHATare the risks and strategies this company may be facing in order to deal with the uncertainties of the Trade War...
-
24) The size of a euro call is 125,000. Today, a U.S. importer places an order for machine tools that will arrive in Houston in 60 days, when he must pay 4,000,000 to the German exporter. Assume that...
-
Transaction Deposits or checking account; transaction account; Savings Deposits or savings account; Time deposits;Money Market Deposit Accounts For each service, describe whether it reflects an asset...
-
You just invested $ 80,000 in a mutual fund account that guarantees to pay you 6 percent interest, compounded annually. At the end of five years, how much money will have accumulated in your...
-
Which of the companies has the lowest accounts receivable turnover in the year 20X2? a. Company A. b. Company B. c. Company C. d. CompanyD. 20X1 20X2 Credit Sales Average Receivables Balance $1.0...
-
John Timms is the sole owner of Sunshine Wholesale Traders, a company which buys fruit from farmers and sells it to supermarkets. All goods are collected from farms and delivered to supermarkets on...
-
Shareholders' funds as at 17 March 2012 were \( 5,629\) million (19 March 2011: \( 5,424\) million), an increase of \( 205\) million. This is mainly attributable to the continued profitable growth of...
-
The following information has been gathered from the accounting records of Pets Parlour: Required Using the accounting equation, calculate: (a) The amount of ownership interest at 31 December Year 4....
-
Lindon Company is the exclusive distributor for an automotive product that sells for $48.00 per unit and has a CM ratio of 30%. The company's fixed expenses are $324,000 per year. The company plans...
-
St. Germaine Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: (Click...
-
..
Study smarter with the SolutionInn App