Other

Intelligent Calculator FAC

Rating

Sold

Pages

Uploaded on

22-08-2021

Written in

2020/2021

This intelligent Excel sheet will calculate everything you need to calculate for FAC automatically. You just have to enter the given information of the exercise into the yellow highlighted fields. The sheet will show you all steps of the calculation and provides you with the final result. Previous entered information are used for continuous calculations (e.g. Initial Investment -> Operating Cash Flow -> Terminal Cash Flow -> Final Decision) Includes: - Present Value (PV, Annuity, Annuity Due, Mixed Stream) - Future Value (FV, Annuity, Annuity Due, Mixed Stream, Deposits needed) - Payback Period - NPV (multiple ways to calculate the NPV) - Initial Investment (Installed Cost, After Tax Proceeds, Change in Net Working Capital) - Operating Cash Flow - Terminal Cash Flow

Show more Read less

Institution

Course

Whoops! We can’t load your doc right now. Try again or contact support.

Report Copyright Violation

Connected book

Chad J. Zutter, Scott B. Smart Principles of Managerial Finance, Global Edition

Edition:Unknown
ISBN:9781292261515
Edition:15

Written for

Institution: Hanzehogeschool Groningen (Hanze)
Study: International Business and Management Studies
Course: FAC (SIM2)

All documents for this subject (1)

Document information

Uploaded on: August 22, 2021
Number of pages: 22
Written in: 2020/2021
Type: Other
Person: Unknown

Subjects

present value
future value
annuity
annuity due
mixed stream
payback period
npv
initial investment
operating cash flow
terminal cash flow
pv
fv

Content preview

Present Value 150000
Interest Rate 0.06
Base Value 1
Number of Periods 18

Future Value 428,150.87 €

Annuity Deposits needed
Annnual payments 150000 Future Value 150000
Interest Rate 0.06 Interest Rate 0.06
Base Value 1 Base Value 1
Number of Periods 18 Number of Periods 18

Future Value 4,635,847.88 € Annual Payments 4,853.48 €

Annuity Due
Annnual payments
Interest Rate
Base Value 1
Number of Periods

Future Value #DIV/0!

Mixed Stream
Year Cash Flow
1 -11500
2 -14000
3 -12900
4 -16000
5 -18000
Rate of interest 8%
NPV -56,902.30 €
Number of Years 5

Future Value 83,608.15 €

,Future Value 428150
Interest Rate 0.06
Base Value 1
Number of Periods 18

Present Value 149,999.69 €

Annuity
Annnual payments 150000
Interest Rate 0.06
Base Value 1
Number of Periods 18

Present Value 1,624,140.52 €

Annuity Due
Annnual payments
Interest Rate
Base Value 1
Number of Periods

Present Value #DIV/0!

Mixed Stream
Year Cash Flow
1 400
2 800
3 500
4 400
5 300
Rate of interest 9%

Present Value 1,904.76 €

, Project A Project B
Year Annual Cash Flow Cummulative Cash Flow Annual Cash Flow
0 - 1,500,000.00 € - 1,500,000.00 € - 1,500,000.00 €
1 400,000.00 € - 1,100,000.00 € 400,000.00 €
2 800,000.00 € - 300,000.00 € 800,000.00 €
3 800,000.00 € 500,000.00 € 800,000.00 €
4 50,000.00 € 550,000.00 € 50,000.00 €
5 20,000.00 € 570,000.00 € 20,000.00 €
6 15,000.00 € 585,000.00 € 15,000.00 €
7 10,000.00 € 595,000.00 € - €
Project Cash Flow 2,095,000.00 € 2,085,000.00 €
Payback Period 1.625 1.625
0.38 €

$19.72

Get access to the full document:

100% satisfaction guarantee

Immediately available after payment

Both online and in PDF

No strings attached

Get to know the seller

xsaturn5x

Also available in package deal

Get to know the seller

xsaturn5x Hanzehogeschool Groningen

View profile

Sold

Member since

4 year

Number of followers

Documents

Last sold

3 year ago

0.0

0 reviews

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller xsaturn5x. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $19.72. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews) 47402 documents were sold in the last 30 days Founded in 2010, the go-to place to buy study notes for 16 years now

Intelligent Calculator FAC

Connected book

Written for

Document information

Subjects

Content preview

Also available in package deal

Get to know the seller

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Didn't get what you expected? Choose another document

Pay as you like, start learning right away

Frequently asked questions

What do I get when I buy this document?

Satisfaction guarantee: how does it work?

Who am I buying these notes from?

Will I be stuck with a subscription?

Can Stuvia be trusted?