Formulas used
Profit Before Tax =B28-B29-B30
tax=B31*20%
Profit after tax=B31-B32
Operating Cashflow=B33+B30
Total cash flow at(year=0)=-100-25
Total Cashflow at (year=5)=F34+30+25
QUESTION 31 Your firm is considering an overseas expansion. Below is the information that you have...
please answer both!!
QUESTION 34 Your is comidering an overseas expansion Below is the information that you have been given in the project: nel Equipment Cost $100m Life of System 5 years Depreciation method Straight line Depreciation Expected overseas sales: 3120 per yew Raw materials: 570m per year Saries for new workers: 510m per year Net Working Capital necessary for plant to operate effectively 525m (assume that this investment is required at the start of the project and is recovered...
Your firm is considering building a $594 million plant to manufacture HDTV circuitry. You expect operating profits (EBITDA) of $140 million per year for the next ten years. The plant will be depreciated on a straight-line basis over ten years (assuming no salvage value for tax purposes). After ten years, the plant will have a salvage value of $291 million (which, since it will be fully depreciated, is then taxable). The project requires $50 million in working capital at the...
Please solve the following case using Excel and submit your
assignment via Blackboard. You should work with your group on the
case assignments (please write the names of all group members).
Jack Tar, CFO of Sheetbend & Halyard Inc. opened the company
confidential envelope. It contained a draft of a competitive bid
for a contract to supply duffel canvas to the U.S. Navy. The cover
memo from Sheetbend's CEO asked Mr. Tar to review the bid before it
was submitted....
Question Completion Status QUESTION 4 Your monthly mortgage payment (principal plus interest) is $1,650. you have a 24-year loan with a fixed interost rate of 0.4 % per month, how much did you borrow from the bank to purchase your house (rounded to the nearest whole dolar)? (Do not enter a dollar sign $ with your answer) 15 points QUESTION 15 points Consider the following sequence of year-end cash flows ΕΟΥ 3 Cash Flow What is the uniform annual equivalent...
Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDSs). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. The company bought some land three years ago for $2.9 million in anticipation of using it as a toxic dump site for waste chemicals, but it...
You and your team are financial consultants who have been hired by a large, publicly traded electronics firm, Brilliant Electronics (BE), a leader in its industry. The company is looking into manufacturing its new product, a machine using sophisticated state of the art technology developed by BE’s R&D team, overseas. This overseas project will last five years. They’ve asked you to evaluate this project and to make a recommendation about whether or not the company should pursue it. BE’s management...
Some proffesional from here request more information but below
is all I have, There is something missing? if not please help me
here
Objective: This activity has the purpose of helping students compute an equivalent annual worth quantity using the software Microsoft Excel. Also to perform a sensitivity analysis. (Objective 7) Student Instructions: Read example to be used to compute an equivalent annual worth cash flow. Example Equivalent Annual Worth with different lives: A mechanical engineer is considering two types...
please I need help for my project
ACC 112 Project 1B The below represents the comparative financial statements of Kamla Corporation. Kamla Corporation Comparative Income Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Net sales (all on account) $1,178,000 $1,034,000 Expenses: Cost of goods sold $808,000 $710,000 Selling and administrative 209,000 225,000 Interest expense 12,000 14,000 Income tax expense 33,400 23,000 Total expenses $1,062,400 $972,000 Net income $115,600 $62,000 2015 $37,000 28,600 149,400 138,800 353,800 782,000...
ACC 112 Project 1B The below represents the comparative financial statements of Kamla Corporation. Kamla Corporation Comparative Income Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Net sales (all on account) $1,238,000 $1,006,000 Expenses: Cost of goods sold $826,000 $706,000 Selling and administrative 208,000 218,000 Interest expense 12,000 14,000 Income tax expense 35,000 23,000 Total expenses $959,000 $1,083,000 $47,000 $155,000 Net income Kamla Corporation Comparative Balance Sheet December 31, 2016 and 2015 2015 2016 Assets Current...
ACC 112 Project 1B The below represents the comparative financial statements of Kamla Corporation. Kamla Corporation Comparative Income Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Net sales (all on account) $1,238,000 $1,006,000 Expenses: Cost of goods sold $826,000 $706,000 Selling and administrative 208,000 218,000 Interest expense 14,000 12,000 Income tax expense 35,000 23,000 Total expenses $1,083,000 $959,000 Net income $155,000 $47,000 || 2015 Kamla Corporation Comparative Balance Sheet December 31, 2016 and 2015 Assets 2016...