Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Corporate Finance

Authors: John B. Guerard Jr. Anureet Saxena, Mustafa Gultekin

2nd Edition

3030435466, 978-3030435462

More Books

Students also viewed these Finance questions

Question

A 300N F 30% d 2 m Answered: 1 week ago

Answered: 1 week ago

Question

Explain the issues of safety unique to small businesses.

Answered: 1 week ago

Question

Describe downsizing.

Answered: 1 week ago

Question

Discuss compensation for contingent workers.

Answered: 1 week ago