Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 3: Interest Rate In this part, calculate the interest rates. Use the Excel Rate function to compute the interest rates. In 2018, one of

Part 3: Interest Rate

In this part, calculate the interest rates. Use the Excel Rate function to compute the interest rates.

  1. In 2018, one of the first copper pennies struck at the Philadelphia mint in 1793 was sold for $300,000. What was the rate of return on this investment? (7 Points)

  1. Calculate the interest rates in the table below using the Excel Rate function. (7 Points)

Present Value

Years

Future Value

Interest Rate

$850

10

$1,380

?

$900

14

$1,750

?

$16,000

25

$142,000

?

$70,500

16

$312,500

?

Part 3: (See https://support.office.com/en-US/article/RATE-function-9F665657-4A7E-4BB7-A030-83FC59E748CE)
E)
Nper Pmt PV FV Rate
F)
Present Value Years Future Value Interest Rate
$850 10 $1,380
$900 14 $1,750
$16,000 25 $142,000
$70,500 16 $312,500

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

Step: 3

blur-text-image

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

The Progressive Audit A Toolkit For Improving Your Organizational Quality Culture

Authors: Robert Pfannerstill

1st Edition

0873896629, 978-0873896627

More Books

Students also viewed these Accounting questions