Date of Note Interest Maturity Date June 10 July 14 April 27

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...
icon
Related questions
Question

Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items. 

 

M
Q
R
1 Function: DATE; Formula: Add, Multiply, Divide; Cell Referencing
2.
3 Using Excel to Compute Interest and Maturity Date
Student Work Area
Required: Provide input into cells shaded in yellow in this template. Use
mathematical formulas with ca references to the Problem area.
4.
PROBLEM
5 Compute interest and find the maturity date for the following notes using
6 Excel's DATE function. Base the interest calculation on 360 days per year.
8
9
Date of Note
Face Value
Interest
Terms in
Date of Note
Maturity Date
Interest
10
Month
Day
Year
Rate %
Days
June 10
$ 80,000
$ 50,000
$ 12,000
11
6.
10
2022
6%
60
12
14
2022
7%
90
July 14
13
4
27
2022
8%
75
14
April 27
15
%24
Transcribed Image Text:M Q R 1 Function: DATE; Formula: Add, Multiply, Divide; Cell Referencing 2. 3 Using Excel to Compute Interest and Maturity Date Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with ca references to the Problem area. 4. PROBLEM 5 Compute interest and find the maturity date for the following notes using 6 Excel's DATE function. Base the interest calculation on 360 days per year. 8 9 Date of Note Face Value Interest Terms in Date of Note Maturity Date Interest 10 Month Day Year Rate % Days June 10 $ 80,000 $ 50,000 $ 12,000 11 6. 10 2022 6% 60 12 14 2022 7% 90 July 14 13 4 27 2022 8% 75 14 April 27 15 %24
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Personal Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning