Question
Andrew plans to open a garment business. This business requires a sewing machine for IDR 300,000,000. If this business is run, Andrew will get a
Andrew plans to open a garment business. This business requires a sewing machine for IDR 300,000,000. If this business is run, Andrew will get a net profit (already taking into account other costs such as room rent, employee salaries, maintenance etc.) of IDR 80,000,000 per year. Andrew will only run his business for five years and the machine after seven years is estimated to still be sold at a price of IDR 100,000,000. use i = 10% How to do the calculation of Rate of Return (RoR) in Excel? I need to do a graph for all sort of i values. RoR is i at Net Present Value (NPV) = 0 (can be seen from graph). Show me how to do the excel.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started