Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

Please assist with question 3

The database shows estimated expenses for the last nine months of the coming year. Define range names for each month and type of expense and use the range names in formulas to find the total for each month and type of expense.
Click the icon to view the estimated expenses for the last nine months of the coming year.
Define range names for each month and type of expense. Which are reasonable range names to give each month?
A. Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec
O B. Cost of Goods, Advert, Salaries, Supplies, Misc
O C. Apr_May_Jun, Jul_Aug_Sept, Oct Nov Dec
O D. Cost, Advert, Salaries, Supplies, Misc
Which are reasonable range names to give each type of expense?
O A.
Cost of Goods, Advert, Salaries, Supplies, Misc
O B.
Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec
C.
Cost, Advert, Salaries, Supplies, Misc
O D. Apr_May_Jun, Jul Aug Sept, Oct Nov Dec
Use the range names in formulas to find the total for each month. Fill in the total for each month below.
(Simplify your answers.)
A
B
April
1 Expenses
2 Cost of Goods $2,550
3 Advertising $2,500
4 Salaries
$18,650
5 Supplies
$1,300
6 Miscellaneous $15,000
Total for Each
7
Month
с
May
$2,880
$2,500
$18,650
$1,360
$15.000
$
D
E
June
$2,950
July
$3,170
$3,000
$2,500
$18,650 $30,000 $30,000
$1,440
$15,400
$1,550
$15,800
$1,550
$16,500
$
$
$
G
H
F
August September October
$3,230 $3,900
$3,000
$2,840
$1,500
$2,500
$30,000 $18,850
$1,500
$16,000
$1,450
$15.300
$
$
$2,600
$1,500
$18,850
C
$1,400
$15,000
$
Budget Forcast (Estimated Expenses)
November December
$2,280
$1,500
$18,850
$1,300
$14,200
$
Expenses April
Cost of Goods $2,550
Advertising $2,500
Salaries
May
June July
$2,880 $2,950 $3,170
$2,500 $2,500 $3,000
$18,650 $18,650 $18,650 $30,000
Supplies $1,300 $1,360 $1,440 $1,550
Miscellaneous $15,000 $15,000 $15,400 $15,800
Print
September October
$3,900 $2,840
$2,500 $1,500
August
November December
$3,230
$2,600 $2,280
$3,000
$1,500 $1,500
$30,000 $30,000 $18,850 $18,850 $18,850
$1,550 $1,500
$1,450
$1,400 $1,300
$16,500 $16,000 $15,300 $15,000 $14,200
Done
D
expand button
Transcribed Image Text:The database shows estimated expenses for the last nine months of the coming year. Define range names for each month and type of expense and use the range names in formulas to find the total for each month and type of expense. Click the icon to view the estimated expenses for the last nine months of the coming year. Define range names for each month and type of expense. Which are reasonable range names to give each month? A. Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec O B. Cost of Goods, Advert, Salaries, Supplies, Misc O C. Apr_May_Jun, Jul_Aug_Sept, Oct Nov Dec O D. Cost, Advert, Salaries, Supplies, Misc Which are reasonable range names to give each type of expense? O A. Cost of Goods, Advert, Salaries, Supplies, Misc O B. Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec C. Cost, Advert, Salaries, Supplies, Misc O D. Apr_May_Jun, Jul Aug Sept, Oct Nov Dec Use the range names in formulas to find the total for each month. Fill in the total for each month below. (Simplify your answers.) A B April 1 Expenses 2 Cost of Goods $2,550 3 Advertising $2,500 4 Salaries $18,650 5 Supplies $1,300 6 Miscellaneous $15,000 Total for Each 7 Month с May $2,880 $2,500 $18,650 $1,360 $15.000 $ D E June $2,950 July $3,170 $3,000 $2,500 $18,650 $30,000 $30,000 $1,440 $15,400 $1,550 $15,800 $1,550 $16,500 $ $ $ G H F August September October $3,230 $3,900 $3,000 $2,840 $1,500 $2,500 $30,000 $18,850 $1,500 $16,000 $1,450 $15.300 $ $ $2,600 $1,500 $18,850 C $1,400 $15,000 $ Budget Forcast (Estimated Expenses) November December $2,280 $1,500 $18,850 $1,300 $14,200 $ Expenses April Cost of Goods $2,550 Advertising $2,500 Salaries May June July $2,880 $2,950 $3,170 $2,500 $2,500 $3,000 $18,650 $18,650 $18,650 $30,000 Supplies $1,300 $1,360 $1,440 $1,550 Miscellaneous $15,000 $15,000 $15,400 $15,800 Print September October $3,900 $2,840 $2,500 $1,500 August November December $3,230 $2,600 $2,280 $3,000 $1,500 $1,500 $30,000 $30,000 $18,850 $18,850 $18,850 $1,550 $1,500 $1,450 $1,400 $1,300 $16,500 $16,000 $15,300 $15,000 $14,200 Done D
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Text book image
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:9781260013962
Author:BREALEY
Publisher:RENT MCG
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage
Text book image
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education