- Questions & Answers
- Accounting
- Computer Science
- Automata or Computationing
- Computer Architecture
- Computer Graphics and Multimedia Applications
- Computer Network Security
- Data Structures
- Database Management System
- Design and Analysis of Algorithms
- Information Technology
- Linux Environment
- Networking
- Operating System
- Software Engineering
- Big Data
- Android
- iOS
- Matlab

- Economics
- Engineering
- Finance
- Thesis
- Management
- Science/Math
- Statistics
- Writing
- Dissertations
- Essays
- Programming
- Healthcare
- Law

- Log in | Sign up

attacted is the corpate finance assignment that needs to be done on one excel sheet but using different tabs for each problem

Instructions Please complete the following: · Problem P17-4 · Problem P17-9 · Problem P18-1 · Problem P18-15 · Problem P19-1 Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems. Please only submit one Excel file with tabs for each problem. There might be some problems where the solution will require graphing. This will require using the graphing function in Excel. If you submit your answer without an Excel graph points will be deducted. If you submit your answer by drawing a graph even if it is correct, points will be deducted. Remember to show all calculations. You must show your calculation and solution. please see the example below. If you do not show how you arrived at your answers, you will not receive credit. Merely showing the formula without the calculations is not sufficient. The problems should be set up in columns or using other appropriate formats—do not hide all steps in formulas behind one answer. I must still be able to see how you arrived at the answer. EXAMPLE OF HOW WORK SHOULD LOOK Please see below · Problem P17-4 Leave and Purchase: JLB Corporation is attempting to determine whether to lease or purchase research equipment. The firm is in the 21% tax bracket, and its after-tax cost of debt is currency 8%. The terms of the lease and of the purchase are as follows: Lease: Annual end-of-year lease payments of $25,200 are required over the three-year life of the lease. All maintenance costs will be paid by the lessor; insurance and other costs will be paid by the lessor; insurance and other costs will be borne by the lessee. The lessee will exercise its option to purchase the asset for $5,000 at the termination of the lease. Purchase: The equipment costs $60,000 and can be financed with a 14% loan requiring annual end-of-year payments of $25,844 for three years. JLB will depreciate the equipment under MACRS using a three-year recovery period. (See Table 4.2 for the applicable depreciation percentages.) JLB will pay $1,800 per year for a service contract that covers all maintenance costs; insurance and other cost will be borne by the JLB, who plans to keep the equipment and use it beyond its three-year recovery period. a. Calculate the after-tax cash out-flows associated with each alternative. b. Calculate the present value of each stream, using the after-tax cost of debt. c. Which alternative lease or purchase would you recommend? why? · Problem P17-9 Conversion ( or stock) value: What is the conversion (or stock) value of each of the following convertible bonds? a. A $1,000-par-value bond that is convertible into 2.5 shares of the common stock. The common stock is currently selling for $50 per share. b. A $1,000 -par-value bond that is convertible into 12.5 shares of common stock. The common stock is currently selling for $42 per share. c. A $1,000-par-value bond that is convertible into 100 shares of common stock. The common stock is currently selling for $ 10.50 per share. · Problem P18-1 Tax effects of acquisition: Connors Shoe Company is contemplating the acquisition of Salines Boots, a firm that has shown large operating tax losses over the past few years. As a result of the acquisition, Connors believes that the total pretax profits of the merger will not change from the present level for 15 years. The tax loss carry forward of Salinas is $800,000 and Connors projects that its annual earnings before taxes will be $280,000 per year for each of the next 15 years. These earnings are assumed to fall within the annual limit legally allowed for the application of the tax loss carry forward resulting from the proposed merger. The corporate tax rate is 21%. a. If Connors does not make the acquisition, what will be the company’s tax liability and earnings after taxes each year over the next 15 years? b. If the acquisition is made, what will be the company’s tax liability and earnings after taxes each year over the next 15 years? c. If Salinas can be acquired for $350,000 in cash, should Connors make the acquisition, judging on the basis of tax considering? (ignore present value) · Problem P18-15 Voluntary settlement: Payments: Jacobi Supply Company recently ran into certain financial difficulties that have resulted in the initiation of voluntary settlement procedures. The firm currently has $150,000 in outstanding debts and approximately $75,000 in liquidatable short-term assets. Indicate, for each of the following plans, whether the plan is an extension, a composition, or a combination of the two. Also, indicate the cash payments and timing of the payments required of the firm under each plan. a. Each creditor will be paid .50 cents on the dollar immediately, and the debts will be considered fully satisfied. b. Each creditor will be paid .80 cents on the dollar in two quarterly installments of .50 cents and .30 cents. The first installment is to be paid in 90 days. c. Each creditor will be paid the full amount of its claims in three installments of .50 cents, .25 cents, and .25 cents on the dollar. The installments will be made in 60-day intervals, beginning in 60 days. d. A group of creditors with claims of $50,000 will be immediately paid in full; the rest will be paid .85 cents on the dollar, payable in 90 days. · Problem P19-1 Exchange rate movements: Suppose a basket of goods in Paris costs euro 113 and the same basket purchased in New York costs $153. a. At what exchange rate between euros and dollars is the cost of the basket of goods the same in each city ? b. Now suppose that over the next year, inflation in France is expected to be 2% while in the U.S. the forecast is for 6% inflation. What exchange rate do you expect a year from today?

Instructions Please complete the following: · Problem P17-4 · Problem P17-9 · Problem P18-1 · Problem P18-15 · Problem P19-1 Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems. Please only submit one Excel file with tabs for each problem. There might be some problems where the solution will require graphing. This will require using the graphing function in Excel. If you submit your answer without an Excel graph points will be deducted. If you submit your answer by drawing a graph even if it is correct, points will be deducted. Remember to show all calculations. You must show your calculation and solution. please see the example below. If you do not show how you arrived at your answers, you will not receive credit. Merely showing the formula without the calculations is not sufficient. The problems should be set up in columns or using other appropriate formats—do not hide all steps in formulas behind one answer. I must still be able to see how you arrived at the answer. EXAMPLE OF HOW WORK SHOULD LOOK Please see below · Problem P17-4 Leave and Purchase: JLB Corporation is attempting to determine whether to lease or purchase research equipment. The firm is in the 21% tax bracket, and its after-tax cost of debt is currency 8%. The terms of the lease and of the purchase are as follows: Lease: Annual end-of-year lease payments of $25,200 are required over the three-year life of the lease. All maintenance costs will be paid by the lessor; insurance and other costs will be paid by the lessor; insurance and other costs will be borne by the lessee. The lessee will exercise its option to purchase the asset for $5,000 at the termination of the lease. Purchase: The equipment costs $60,000 and can be financed with a 14% loan requiring annual end-of-year payments of $25,844 for three years. JLB will depreciate the equipment under MACRS using a three-year recovery period. (See Table 4.2 for the applicable depreciation percentages.) JLB will pay $1,800 per year for a service contract that covers all maintenance costs; insurance and other cost will be borne by the JLB, who plans to keep the equipment and use it beyond its three-year recovery period. a. Calculate the after-tax cash out-flows associated with each alternative. b. Calculate the present value of each stream, using the after-tax cost of debt. c. Which alternative lease or purchase would you recommend? why? · Problem P17-9 Conversion ( or stock) value: What is the conversion (or stock) value of each of the following convertible bonds? a. A $1,000-par-value bond that is convertible into 2.5 shares of the common stock. The common stock is currently selling for $50 per share. b. A $1,000 -par-value bond that is convertible into 12.5 shares of common stock. The common stock is currently selling for $42 per share. c. A $1,000-par-value bond that is convertible into 100 shares of common stock. The common stock is currently selling for $ 10.50 per share. · Problem P18-1 Tax effects of acquisition: Connors Shoe Company is contemplating the acquisition of Salines Boots, a firm that has shown large operating tax losses over the past few years. As a result of the acquisition, Connors believes that the total pretax profits of the merger will not change from the present level for 15 years. The tax loss carry forward of Salinas is $800,000 and Connors projects that its annual earnings before taxes will be $280,000 per year for each of the next 15 years. These earnings are assumed to fall within the annual limit legally allowed for the application of the tax loss carry forward resulting from the proposed merger. The corporate tax rate is 21%. a. If Connors does not make the acquisition, what will be the company’s tax liability and earnings after taxes each year over the next 15 years? b. If the acquisition is made, what will be the company’s tax liability and earnings after taxes each year over the next 15 years? c. If Salinas can be acquired for $350,000 in cash, should Connors make the acquisition, judging on the basis of tax considering? (ignore present value) · Problem P18-15 Voluntary settlement: Payments: Jacobi Supply Company recently ran into certain financial difficulties that have resulted in the initiation of voluntary settlement procedures. The firm currently has $150,000 in outstanding debts and approximately $75,000 in liquidatable short-term assets. Indicate, for each of the following plans, whether the plan is an extension, a composition, or a combination of the two. Also, indicate the cash payments and timing of the payments required of the firm under each plan. a. Each creditor will be paid .50 cents on the dollar immediately, and the debts will be considered fully satisfied. b. Each creditor will be paid .80 cents on the dollar in two quarterly installments of .50 cents and .30 cents. The first installment is to be paid in 90 days. c. Each creditor will be paid the full amount of its claims in three installments of .50 cents, .25 cents, and .25 cents on the dollar. The installments will be made in 60-day intervals, beginning in 60 days. d. A group of creditors with claims of $50,000 will be immediately paid in full; the rest will be paid .85 cents on the dollar, payable in 90 days. · Problem P19-1 Exchange rate movements: Suppose a basket of goods in Paris costs euro 113 and the same basket purchased in New York costs $153. a. At what exchange rate between euros and dollars is the cost of the basket of goods the same in each city ? b. Now suppose that over the next year, inflation in France is expected to be 2% while in the U.S. the forecast is for 6% inflation. What exchange rate do you expect a year from today?

Answered 5 days AfterFeb 25, 2024

Every year cash outflow = year-end-cash-flow (1 -tax rate)

$25,200 * (1-.21)

$19,908.00

CFAT(y=1) $19,908.00

CFAT(y=2) $19,908.00

CFAT(y=3) CFAT + Termination Value

$19,908 + $5000

$24,908

A B

Year Payment Maintenance Depreciation PBIT Interest PBT Taxes @ 21% PAT CFAT (A + B)

1 $25,844 $1,800.00 $9,122.52 $18,521.48 $8,400.00 $10,121.48 $2,125.51 $7,995.97 $17,118.49

2 $25,844 $1,800.00 $9,122.52 $18,521.48 $5,958.00 $12,563.48 $2,638.33 $9,925.15 $19,047.67

3 $25,844 $1,800.00 $9,122.52 $18,521.48 $3,174.00 $15,347.48 $3,222.97 $12,124.51 $21,247.03

PVIF @ 8% for 1, 2 and 3 years

r = after tax cost of debt

t = time period

PV Factor 1/(1+.08)^t

Lease Method : CFAT

Year CFAT PV Factor PV(CFAT)

1 $19,908.00 0.9259259259 $18,433.33

2 $19,908.00 0.8573388203 $17,067.90

3 $24,908.00 0.793832241 $19,772.77

$55,274.01 A

Purchase Method:

Year CFAT PV Factor PV(CFAT)

1 $17,118.49 0.9259259259 $15,850.45

2 $19,047.67 0.8573388203 $16,330.31

3 $21,247.03 0.793832241 $16,866.58

$49,047.34 B

Firem should purchase Equipment since they will be saving $6,227

Total Cash saving A - B

-$6,226.67

Working notes

Year Annual Payment Principal Interest Interest Amount Principal component Year end Principal o/s

1 $25,844 60000 14% 8400 $17,444 $42,556

2 $25,844 $42,556 14% 5958 $19,886 $22,670

3 $25,844 $22,670 14% 3173.8 $22,670 -$0

Problem P17-9

a No. of Shares to be convereted 2.5 A

Current Stock Price $50.00 B

Conversion Value A * B

Conversion Value $125.00

b No. of Shares to be convereted 12.5 A

Current Stock Price $42.00 B

Conversion Value A * B

Conversion Value $525.00

c No. of Shares to be convereted 100 A

Current Stock Price $10.50 B

Conversion Value A * B

Conversion Value $1,050.00

Problem P18-1

a If Connors does not make the acquisition, the company's tax liability and earnings after taxes each year over the next 15 years can be calculated as follows:

Since Connors did not acquire Salines Boots, they wikll n ot be able to utilize Tax loss carryover $800,000.00

Tax Liability Taxable Income * Corporate TaX rate

Earning Before Tax (EBT) $280,000.00 A

Corporate Tax...

SOLUTION.PDF## Answer To This Question Is Available To Download

- Task: Your company wants to analyze the opportunity to invest in a Wind Farm of 38.4MW capacity in Spain. Your task as an analyst is to develop a financial model in order to determine whether the...Jul 16, 2024
- InstructionsPlease complete the following:· Problem P15-1· Problem P15-4· Problem P15-13· Problem P16-2· Case - Kanton CompanyCarry all calculations to TWO decimal places to reduce...SolvedFeb 15, 2024
- Instructions Please complete the following:· Problem P13-1· Problem P13-15· Problem P13-21· Problem P14-8· Problem P14-14Carry all calculations to TWO decimal places to reduce rounding...SolvedFeb 12, 2024
- InstructionsPlease complete the following · Problem P10-24· Problem P10-28· Problem P11-11· Problem P11-16· Problem P12-12· Problem P12-20· Problem P12-28Carry all calculations to...SolvedFeb 07, 2024
- InstructionsPlease complete the following:· Problem P8-18· Problem P8-28· Problem P9-5· Problem P9-15· Integrative Case 4 - Enviro Plastics CompanyGeneral Instructions for...SolvedFeb 05, 2024
- InstructionsPlease complete the following:· Problem P6-9· Problem P6-17· Problem P6-31· Problem P7-20· Problem P7-23Carry all calculations to TWO decimal places to reduce rounding error,...SolvedFeb 02, 2024
- InstructionsPlease complete the following:Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems.Remember to show all calculations. You must...SolvedJan 30, 2024
- CASE STUDY ON EXCEL MUST SHOW WORK AND CALCULATIONSJan 30, 2024
- Assignment Notes: Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems.Remember to show all calculations.General Instructions for Written...SolvedJan 26, 2024
- ALL WORK MUST BE DONE ON EXCEL SPREEDSHEETS PLEASE USE SEPERATE SHEET FOR EACH PROBLEM P1-4Marginal cost-benefit analysis and the goal of the firm Monsanto Corporation is considering the...SolvedJan 20, 2024

Copy and Paste Your Assignment Here

Copyright © 2024. All rights reserved.