28. 29. Hwan also wants to determine the sum-of-years depreciation balance for the first year and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
28. 29. Hwan also wants to determine the sum-of-years depreciation balance for the first year and the last year of the useful life of the construction equipment. Determine these amounts as follows: a. b. For the yearly allowance for the first year, use a function to calculate the sum-of- years depreciation balance, using a cell reference to Year 1 of the declining balance section as the current period. For the yearly allowance for the last year, use a function to calculate the sum-of- years depreciation balance, using a cell reference to Year 10 of the declining balance as the current period. Go to the Investments & Projections worksheet. Besides using a bank loan to fund their upcoming expansion, W&K Engineering is looking for investors. This worksheet should show the returns potential investors could realize if they invested a total of $400,000 in the company. Hwan knows that a desirable rate of return would be 9 percent. He also estimates the investment would pay different amounts each year, as shown in the repayment schedule section. Calculate the net present value of the investment and the internal rate of return. a. b. Next to the cell labeled "Present value", use a function to calculate the net present value of the investment in funding the company's expansion. Use a cell reference to the target rate of return value as the rate argument, as well as the payments in Years 1-10 as the returns paid to investors. (Hint: If a Formula Omits Adjacent Cell error warning appears, ignore it.) Next, in the appropriate cell, use a function to calculate the internal rate of return for the investment. Use a cell reference to the payments for Years 1-10 as the returns paid to investors. 30. The Monthly Revenue Projections scatter chart in the range E3:K20 is based on monthly revenue estimates listed on the hidden Monthly Revenue Projections worksheet. Hwan wants to include a trendline for this chart that shows investors how revenues will most likely increase quickly at first and then level off in later months. Modify the Monthly Revenue Projections scatter chart as follows to include a logarithmic trendline: a. Add a Trendline to the Monthly Revenue Projections scatter chart. b. Format the trendline to use the Logarithmic option. 28. 29. Hwan also wants to determine the sum-of-years depreciation balance for the first year and the last year of the useful life of the construction equipment. Determine these amounts as follows: a. b. For the yearly allowance for the first year, use a function to calculate the sum-of- years depreciation balance, using a cell reference to Year 1 of the declining balance section as the current period. For the yearly allowance for the last year, use a function to calculate the sum-of- years depreciation balance, using a cell reference to Year 10 of the declining balance as the current period. Go to the Investments & Projections worksheet. Besides using a bank loan to fund their upcoming expansion, W&K Engineering is looking for investors. This worksheet should show the returns potential investors could realize if they invested a total of $400,000 in the company. Hwan knows that a desirable rate of return would be 9 percent. He also estimates the investment would pay different amounts each year, as shown in the repayment schedule section. Calculate the net present value of the investment and the internal rate of return. a. b. Next to the cell labeled "Present value", use a function to calculate the net present value of the investment in funding the company's expansion. Use a cell reference to the target rate of return value as the rate argument, as well as the payments in Years 1-10 as the returns paid to investors. (Hint: If a Formula Omits Adjacent Cell error warning appears, ignore it.) Next, in the appropriate cell, use a function to calculate the internal rate of return for the investment. Use a cell reference to the payments for Years 1-10 as the returns paid to investors. 30. The Monthly Revenue Projections scatter chart in the range E3:K20 is based on monthly revenue estimates listed on the hidden Monthly Revenue Projections worksheet. Hwan wants to include a trendline for this chart that shows investors how revenues will most likely increase quickly at first and then level off in later months. Modify the Monthly Revenue Projections scatter chart as follows to include a logarithmic trendline: a. Add a Trendline to the Monthly Revenue Projections scatter chart. b. Format the trendline to use the Logarithmic option.
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Change the caliper to 0.01 from 0.02 and do the analysis over. a. How many observations in the treatment group were not matched to a comparison group observation? b. Think about the matches when...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Nancy has active modified adjusted gross income before passive losses of $75,000. She has a loss of $5,000 on a rental property she actively manages. How much of the loss is she allowed to take...
-
What are minimum lease payments?
-
Refer to the situation in Problem 6. Suppose the manager of MamaMia's current order quantity is 200 boxes. How much can be saved by adopting an EOQ versus their current Q = 200?
-
You are considering buying a 15-year, annual-coupon bond that has a coupon rate of 7 percent and a YTM of 9 percent. What should be the price of this bond? a. $838.79 b. $1,000.00 c. $1,057.17 d....
-
In the National Basketball Association, the top free throw shooters usually have probability of about 0.90 of making any given free throw. a. During a game, one such player (Dolph Schayes) shot 10...
-
26 20 25 7 28 29 29 30 Here are the numbers of times 9 people ate out last month. 6, 4, 7, 5, 4, 4, 7, 5, 5 Send data to calculator Find the modes of this data set. If there is more than one mode,...
-
The EG Manufacturing has three factories (Purple, Blue, and Orange) and three stores (Alpha, Beta, and Gamma). The following table shows the shipping costs between each factory and store, the factory...
-
What is the most important information to include when writing about implementing a new ERP system for a company? What are ways to help improve and maintain? What things should the company be on the...
-
List ethical practices when interacting with children. What are confidential and ethical practices regarding hiring and supervising employees? What professional development for staff is available...
-
Problem 5. Calls from n telephones are multiplexed on a transmission line with m circuits. Each call takes up one full circuit. Each telephone alternates between an idle state and an active state....
-
JM Electronics is considering two plans for raising $2,000,000 to expand operations. Plan A is to issue 10% bonds payable, and plan B is to issue 100,000 shares of common stock. Before any new...
-
What ethical considerations arise when implementing performance management systems that utilize algorithmic decision-making processes, and how can organizations ensure fairness and transparency in...
-
2 . Assume that 5 0 , 0 0 0 oil drums are needed each year. What will be the total relevant cost of 5 0 , 0 0 0 oil drums if they are manufactured internally? What would be the per unit cost of each...
-
What are the six activities involved in the physical supply/distribution system?
-
for determining whether operations have been discontinued and the problems that might arise in applying them. 5 Annual accounts have been put into such a straitjacket overemphasis on uniform...
-
The directors of Ufool Ltd are aware that a sizeable number of shareholders, although still a minority, are extremely unhappy with current dividend levels and are agitating for larger distributions....
-
Explain the conditions set out in IFRS
Study smarter with the SolutionInn App