SUBJECT 1 *** Please do the calculations analytically on excel don't just post functions :)...
90.2K
Verified Solution
Question
Accounting
SUBJECT 1
*** Please do the calculations analytically on excel don't just post functions :) A photovoltaic production company is considering the creation of a solar Led projector new generation with an operating time of 8 hours. Table 1 shows the provisions financial data resulting from market research. For this investment additional mechanical equipment worth 200,000 is required, transport costs of 3,000 and installation costs 2,500. The useful life of the machines as well as the product life cycle is 5 years. At the end of the year the machines will be sold instead of 30,000.
Years | |||||
1 | 2 | 3 | 4 | 5 | |
Sales in units | 1500 | 2500 | 4000 | 3000 | 1500 |
Average variable cost per unit | 13 | 17 | 20 | 20 | 20 |
Price per unit | 40 | 45 | 50 | 50 | 50 |
administrative and disposal costs | 2000 | 2500 | 3000 | 3500 | 3000 |
working capital | 2000 | 2500 | 2000 | 1500 | 1000 |
Years | |||||
1 | 2 | 3 | 4 | 5 | |
Sales in units | 1500 | 2500 | 4000 | 3000 | 1500 |
Average variable cost per unit | 13 | 17 | 20 | 20 | 20 |
Price per unit | 40 | 45 | 50 | 50 | 50 |
administrative and disposal costs | 2000 | 2500 | 3000 | 3500 | 3000 |
working capital | 2000 | 2500 | 2000 | 1500 | 1000 |
The corporate tax rate is 22%, the cost of capital is 8% pa basis and the company applies the straight line method in the calculation of depreciation. Assuming that the annual cash flows occur at the end of each year, you call: A) Calculate the net cash flows per year. (Grades 1.5) B) To evaluate the above proposal using the Net Present Value method (KPA). (0.50 points) C) To evaluate the above proposal using the Internal Rate of Return method (EBA). (0.50 points)
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.