A proposed project will provide the capability to produce a specialized product estimated to have a short market?(sales) life. Based on an? after-tax analysis using the PW? method, what minimum amount of equivalent uniform annual revenue is required to justify the project? economically?
The minimum amount of equivalent uniform annual revenue that is required to justify the project economically is
?$__________thousand.{C}{C}{C}{C}
*Capital investment is ?$1,040,000.
?• The cost of depreciable? property, which is part of the $1,040,000 total estimated project? cost, is
?$460,000
•?Assume, for? simplicity, that the depreciable property is in the MACRS? (GDS) three-year property class.
•The analysis period is three years.
•Annual operating and maintenance expenses are $611,000 in the first? year, and they increase at the rate of 5%
per year? (i.e.,f equals=5?%) thereafter.
•Estimated MV of depreciable property from the project at the end of three years is $340,000.
•Federal income tax rate=35?%; state income tax rate=3?%.
•MARR? (after taxes) is 12% per year.
Use the? half-year time convention for depreciation in the last year.
Please help, ive tried a few times and keep getting the wrong answer
If you could include the excel chart with the formulas that would be awesome. THanks
In: Finance
Lavage Rapide is a Canadian company that owns and operates a large automatic carwash facility near Montreal. The following table provides data concerning the company’s costs:
| Fixed Cost per Month |
Cost per Car Washed |
||||
| Cleaning supplies | $ | 0.50 | |||
| Electricity | $ | 1,100 | $ | 0.06 | |
| Maintenance | $ | 0.10 | |||
| Wages and salaries | $ | 5,000 | $ | 0.30 | |
| Depreciation | $ | 8,200 | |||
| Rent | $ | 1,900 | |||
| Administrative expenses | $ | 1,600 | $ | 0.01 | |
For example, electricity costs are $1,100 per month plus $0.06 per car washed. The company expects to wash 8,400 cars in August and to collect an average of $6.80 per car washed.
The actual operating results for August appear below.
| Lavage Rapide Income Statement For the Month Ended August 31 |
||
| Actual cars washed | 8,500 | |
| Revenue | $ | 59,220 |
| Expenses: | ||
| Cleaning supplies | 4,700 | |
| Electricity | 1,574 | |
| Maintenance | 1,080 | |
| Wages and salaries | 7,880 | |
| Depreciation | 8,200 | |
| Rent | 2,100 | |
| Administrative expenses | 1,584 | |
| Total expense | 27,118 | |
| Net operating income | $ | 32,102 |
Required:
Complete the flexible budget performance report that shows the company’s activity variances and revenue and spending variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Hawk Homes, Inc., makes one type of birdhouse that it sells for
$29.60 each. Its variable cost is $13.90 per house, and its fixed
costs total $13,611.90 per year. Hawk currently has the capacity to
produce up to 2,500 birdhouses per year, so its relevant range is 0
to 2,500 houses.
Required:
1. Prepare a contribution margin income statement for Hawk
assuming it sells 1,240 birdhouses this year. (Enter your
answers rounded to 2 decimal places.)
2. Without any calculations, determine Hawk’s
total contribution margin if the company breaks even.
(Enter your answers rounded to 2 decimal
places.)
3. Calculate Hawk’s contribution margin per unit
and its contribution margin ratio. (Round your answers to 2
decimal places. (i.e. .1234 should be entered as
12.34%.))
4. Calculate Hawk’s break-even point in number of
units and in sales revenue. (Round your "Sales Revenue"
answer to 2 decimal places and "Unit" answer to the nearest whole
number.)
5. Suppose Hawk wants to earn $22,000 this year.
Determine how many birdhouses it must sell to generate this amount
of profit. (Round up to the next whole
number.)
In: Accounting
Below is the variance report
| Prior year | |||||
| Item | Budget | Actual | Variance | Variance % | Actual |
| Days in time period | 31 | 31 | 31 | ||
| Staffed Beds | 20 | 20 | 20 | ||
| Patient days | 527 | 498 | (29.0) | -5.5% | 415 |
| Total RN FTEs | 45.1 | 50.1 | (5.0) | -11.1% | 36.7 |
| Revenue: | |||||
| Gross patient revenue | $460,450 | $441.932 | ($18,518) | -4.0% | $417,883 |
| Personnel Expense: | |||||
| Total salaries and wages | $171,920 | $192,845 | ($20,925) | -12.2% | $141,552 |
| Benefits | $51,576 | $52,797 | ($1,221) | -2.4% | $42,466 |
| Total personnel expenses | $223,496 | $245,642 | ($22,146) | -9.9% | $184,018 |
| Overtime wages % | 2.0% | 6.1% | 3.2% | ||
| Personnel cost PPD | $424 | $493 | ($69) | -16.3% | $327 |
| Personnel cost FTE | $4,960 | $4,908 | $52 | 1.1% | $3,697 |
| Non-personnel expense: | |||||
| Medical Supplies | $23,700 | $23,498 | $202 | 0.9% | $21,839 |
| Depreciation | $10,000 | $10,000 | $0 | 0.0% | $10,000 |
| Other non-personnel | $3,500 | $2,899 | $601 | 17.2% | $2,734 |
| Total non-personnel | $37,200 | $36,397 | $803 | 2.2% | $34,573 |
| Total Expenses | $260,696 | $282,039 | ($21,343) | -8.2% | $218,591 |
Review all components of the report and determine where variances occur, if any. Discuss your conclusions and recommendations as if you are the Nurse Executive reviewing this report with the unit manager
In: Accounting
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs:
| Fixed Cost per Month |
Cost per Car Washed |
||||||
| Cleaning supplies | $ | 0.60 | |||||
| Electricity | $ | 1,300 | $ | 0.07 | |||
| Maintenance | $ | 0.10 | |||||
| Wages and salaries | $ | 4,500 | $ | 0.40 | |||
| Depreciation | $ | 8,500 | |||||
| Rent | $ | 2,100 | |||||
| Administrative expenses | $ | 1,500 | $ | 0.02 | |||
For example, electricity costs are $1,300 per month plus $0.07 per car washed. The company expects to wash 8,400 cars in August and to collect an average of $6.30 per car washed.
The actual operating results for August are as follows:
| Lavage Rapide | ||
| Income Statement | ||
| For the Month Ended August 31 | ||
| Actual cars washed | 8,500 | |
| Revenue | $ | 55,020 |
| Expenses: | ||
| Cleaning supplies | 5,540 | |
| Electricity | 1,858 | |
| Maintenance | 1,080 | |
| Wages and salaries | 8,220 | |
| Depreciation | 8,500 | |
| Rent | 2,300 | |
| Administrative expenses | 1,568 | |
| Total expense | 29,066 | |
| Net operating income | $ | 25,954 |
Required:
Prepare a flexible budget performance report that shows the company’s revenue and spending variances and activity variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
"A firm is considering purchasing a new milling machine and has
collected the following information for its income statement and
cash flow statement. However, this income statement was calculated
as if there is no inflation! All dollars are expressed in constant
(year-0) dollars. Recalculate the income and cash flow statement by
assuming there is a general (average) inflation of 2.6% applied to
revenue, O&M, and salvage value.
- The firm will pay back the loan in 2 years, and the annual loan
payment is $26,571.
- The tax rate is 38%.
- The revenue for year 1 is $40,000 and $36,000 for year 2.
- O&M for year 1 is $8,000 and $11,000 for year 2.
- The interest paid on the debt is $2743 for year 1 and $1409 for
year 2.
- The taxable income is $19,111 for year 1 and $14,897 for year
2.
- The income taxes are $7,262 for year 1 and $5,661 for year
2.
- The milling machine costs $71,000.
- The salvage value at the end of year 2 is $48,000.
Calculate the IRR of the cash flow based on actual dollars. Express
your answer as a percentage between 0 and 100.
You should calculate the depreciation based on the information
given in the problem, but do not refer to the MACRS table. You will
also need to calculate the amount that is borrowed and that goes to
the principal on the debt in years 1 and 2."
In: Economics
"A firm is considering purchasing a new milling machine and has
collected the following information for its income statement and
cash flow statement. However, this income statement was calculated
as if there is no inflation! All dollars are expressed in constant
(year-0) dollars. Recalculate the income and cash flow statement by
assuming there is a general (average) inflation of 4.7% applied to
revenue, O&M, and salvage value.
- The firm will pay back the loan in 2 years, and the annual loan
payment is $15,796.
- The tax rate is 39%.
- The revenue for year 1 is $36,000 and $27,000 for year 2.
- O&M for year 1 is $12,000 and $13,500 for year 2.
- The interest paid on the debt is $2427 for year 1 and $1264 for
year 2.
- The taxable income is $12,713 for year 1 and $4,644 for year
2.
- The income taxes are $4,958 for year 1 and $1,811 for year
2.
- The milling machine costs $62,000.
- The salvage value at the end of year 2 is $47,000.
Calculate the IRR of the cash flow based on actual dollars. Express
your answer as a percentage between 0 and 100.
You should calculate the depreciation based on the information
given in the problem, but do not refer to the MACRS table. You will
also need to calculate the amount that is borrowed and that goes to
the principal on the debt in years 1 and 2."
In: Accounting
1) When a service has been performed but no cash has been received, which of the following statements is true?
Select one:
a. No journal entry is made.
b. The entry includes a debit to Accounts payable.
c. The entry includes a credit to Unearned revenue.
d. The entry includes a debit to Accounts receivable.
2) Adjusting entries are:
Select one:
a. not necessary if the accounting system is operating properly.
b. usually required before financial statements are prepared.
c. made whenever management desires to change an account balance.
d. made to Statement of Financial Position accounts only.
3) Failure to prepare an adjusting entry at the end of the period to record an accrued expense would cause:
Select one:
a. an overstatement of assets and an overstatement of liabilities.
b. an understatement of expenses and an understatement of liabilities.
c. no any understatement or overstatement.
d. profit to be understated.
4) Which of the following is not a liability?
Select one:
a. Salaries and wages payables
b. GST collected
c. Revenue received in advance
d. GST paid
5) A credit entry to a liability account:
Select one:
a. indicates a decrease in the amount owed to creditors.
b. indicates an increase in the amount owed to creditors.
c. is an error.
d. MUST be accompanied by a debit to an asset account.
In: Accounting
Instructions
(a) Prepare a multiple-step income statement.
(b) Prepare a retained earnings statement.
Porter Corporation's capital structure consists of 50,000 shares of common stock. At December 31, 2010 an analysis of the accounts and discussions with company officials revealed the following information:
Sales $1,100,000
Purchase discounts 18,000
Purchases 642,000
Income from operations of discontinued product line 35,000
Loss on disposal of discontinued production line 70,000
Selling expenses 128,000
Cash 60,000
Accounts receivable 90,000
Unrealized gain on available for sale securities 12,000
Common stock 200,000
Accumulated depreciation – machinery 180,000
Dividend revenue 8,000
Inventory, January 1, 2010 152,000
Inventory, December 31, 2010 125,000
Unearned service revenue 4,400
Interest payable 1,000
Land 370,000
Retained earnings, January 1, 2010 290,000
Interest expense 17,000
Administrative expenses 170,000
Dividends declared 24,000
Allowance for doubtful accounts 5,000
Notes payable (maturity 7/1/13) 200,000
Machinery 450,000
Materials 40,000
Accounts payable 60,000
Pension loss from minimum pension adjustment 20,000
Correction of error – overstatement of depreciation expense in 2015 32,000
Assume an income tax rate of 30%
In: Accounting
Lavage Rapide is a Canadian company that owns and operates a large automatic carwash facility near Montreal. The following table provides data concerning the company’s costs:
| Fixed Cost per Month |
Cost per Car Washed |
||||
| Cleaning supplies | $ | 0.50 | |||
| Electricity | $ | 1,100 | $ | 0.06 | |
| Maintenance | $ | 0.10 | |||
| Wages and salaries | $ | 5,000 | $ | 0.30 | |
| Depreciation | $ | 8,200 | |||
| Rent | $ | 1,900 | |||
| Administrative expenses | $ | 1,600 | $ | 0.01 | |
For example, electricity costs are $1,100 per month plus $0.06 per car washed. The company expects to wash 8,400 cars in August and to collect an average of $6.80 per car washed.
The actual operating results for August appear below.
| Lavage Rapide Income Statement For the Month Ended August 31 |
||
| Actual cars washed | 8,500 | |
| Revenue | $ | 59,220 |
| Expenses: | ||
| Cleaning supplies | 4,700 | |
| Electricity | 1,574 | |
| Maintenance | 1,080 | |
| Wages and salaries | 7,880 | |
| Depreciation | 8,200 | |
| Rent | 2,100 | |
| Administrative expenses | 1,584 | |
| Total expense | 27,118 | |
| Net operating income | $ | 32,102 |
Required:
Complete the flexible budget performance report that shows the company’s activity variances and revenue and spending variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting