Question
In: Finance
Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of...
Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of return by hand (i.e. no financial calculator or Excel routine). For this problem assume a 7-year property, MACRS depreciation is used, 21% corporate tax rate, an initial cost of $800,000, an annual benefit of $150,000 and a salvage value of $100,000. Do not forget the recaptured depreciation.
Solutions
jeff jeffy answered 1 year agoRelated Solutions
Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of...
Complete a spreadsheet (by hand or by Excel) and then determine
the after-tax internal rate of return by hand (i.e. no financial
calculator or Excel routine). For this problem assume a 10-year
analysis period, double declining depreciation is used, 21%
corporate tax rate, an initial cost of $200,000, an annual benefit
of $60,000 and no salvage value but instead you must pay a disposal
fee of $20,000 that your corporate accountant determined is 100%
tax deductible.
To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be...
To complete this comprehensive exercise, use the Excel
spreadsheet program. In this exercise you will be using linear
programming and Solver in Excel to solve the problem described in
the following scenario. At Goodman Shipping, the load master wants
to determine the mix of cargo to be carried on the next trip. The
ship's volume limit for cargo is 100,000 cubic meters, and its
weight capacity is 2,310 tons. The master has five different types
of cargo from which to...
Determine the minimum and maximum internal rate of return for the following cash flow. Use Excel....
Determine the minimum and maximum internal rate of return for
the following cash flow. Use Excel.
Year
Net Cash
0
-2500
1
1500
2
1000
3
-1500
4
900
5
500
*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit;...
*Complete the problems in an Excel spreadsheet. Be sure
to show your work to receive credit; no hard keys.
Problem 2-1: Preparing Financial Statements
Information below is for Warner Manufacturing, Inc. for the year
ended December 31, 20x1 except where beginning of year numbers
indicated. All amounts in SAR unless otherwise stated.
Using the information below:
1. Prepare an income statement with the proper title
2. Prepare end of year balance sheet with the proper title
3. Calculate net working...
*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit;...
*Complete the problems in an Excel spreadsheet. Be sure
to show your work to receive credit; no hard keys.
Problem 2-1: Preparing Financial Statements
Information below is for Warner Manufacturing, Inc. for the year
ended December 31, 20x1 except where beginning of year numbers
indicated. All amounts in SAR unless otherwise stated.
Using the information below:
1. Prepare an income statement with the proper title
2. Prepare end of year balance sheet with the proper title
3. Calculate net working...
Discuss what options of internal controls and audit trails are available in this spreadsheet program, EXCEL...
Discuss what options of internal controls and audit trails are
available in this spreadsheet program, EXCEL and how these work in
terms of data accuracy, security and integrity. List at least two
examples for each of the internal control procedure and the audit
trail feature.
Determine all items that will be deducted before the AGI calculation. In a MS Excel spreadsheet,...
Determine all items that will be deducted before the AGI
calculation. In a MS Excel spreadsheet, list all deductible items
in column A. In column B, determine where that deduction should
appear on Form 1040 (for tax year 2017).
Taxpayer Information
Name: Bryan Jones
Address: 1200 Main St.
Green Bay, Wisconsin 12345
DOB: 5/6/1976
Filing Status: Single
SSN: 500-10-2000
Occupation: Staff Accountant
INCOME INFORMATION:
Wages and Compensation
The following information is taken...
Depreciation Problem: (8pts) ---- Please complete using Excel or by hand. A machine was purchased for...
Depreciation Problem: (8pts) ---- Please complete using Excel or
by hand.
A machine was purchased for $92,000 and had a depreciable life of
five years and a depreciable salvage value of $5,000. Using the
following depreciation methods; Straight Line, Sum-OfYears’ Digits,
Double Declining Balance, and MACRS(with a 5 year property
class):
a. Create a depreciation schedule
The owner has been offered to sell the machine in year 2 for
$50,000.
b. Calculate if the company will see a gain or...
You will complete a capital budgeting Excel spreadsheet solution based on: Cost of new equipment &nb
You will complete a capital budgeting Excel spreadsheet solution
based on:
Cost of new
equipment
$14,800,000
Shipping and
installation
200,000
Unit sales
Year
1
70,000
Year 2
120,000
Year 3
120,000
Year
4
80,000
Year
5
70,000
Sales price = $300 / unit in years 1-4 and $250/unit in year
5
Variable cost = $140 / unit
Fixed cost = $700,000 per year for all 5 years
Working capital : $200,000 at start of project, recovered at
end
Depreciation =...
Please use ONLY one Excel file to complete this case study, and use one spreadsheet for...
Please use ONLY one Excel file to complete this case study, and
use one spreadsheet for each problem.
Develop a linear regression model to predict Wal-Mart revenue,
using CPI as the only independent variable.
Develop a linear regression model to predict Wal-Mart revenue,
using Personal Consumption as the only independent variable.
Develop a linear regression model to predict Wal-Mart revenue,
using Retail Sales Index as the only independent variable.
Which of these three models is the best? Use
R-square values, Significance...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- During his project presentation, Bob falls sick and performs poorly. However, his colleague, Dan, concludes that...
- A sample human input file that contains test values that a human would enter on the...
- A solution is prepared by dissolving 15 ml of methanol in 150.0 ml water at 25...
- Consider a newlywed who is planning a wedding anniversary gift of a trip to Canada for...
- We are evaluating a project that costs $868,000, has a life of eight years, and has...
- a.) Given sample data: 61.2, 61.9, 62.8, 63.1, 64.0, 64.3, 64.9, 65.5, 66.3 and 67.9, test...
- A research paper describes an experiment in which 74 men were assigned at random to one...
ADVERTISEMENT