Need help completing an Online Excel Homework and Test

User Generated

QvbOenaqb

Business Finance

Description

Hello,

I need someone experienced with Excel to help complete a homework assignment and test for my Small Business Economics & Management class. THE HOMEWORK ASSIGNMENT IS CALLED "AMORTIZATION" AND THE TEST IS CALLED "EXAM 2". Attached to this question are various images that will help you navigate the website. You will have full access to the website, and can use the resources in the Course Content folder.

I need a 90% and above on the test and a similar result on the homework, in addition to following the guidelines. DO NOT SUBMIT DIRECTLY OR I WILL HAVE TO ASK FOR A REFUND.

Unformatted Attachment Preview

1 8 6 5 THE UNIVERSITY OF UMaine-Bb UMS Resources UMS Academy MAINE Omkar Shinde 6 Add Module Personalize Page tự System Notices - My Tasks System maintenance windows are available on our calendar: http://support.courses.maine.edu/blackboard-support/calendar My Tasks: BUA220-0003: Legal Environment of Bus (Fall 2018): Read 1984 and do bookreport by 9/14 Student Announcements & Events BUA327-0001: Business and Society (Spring 2019): Catalog Published Read Silent Spring by 2/5 Grad School Orientation ECO190-WINT: World Food Supply, Pop & Envir (Winter Session 2018/2019): Student Dates & Deadlines Cover book and Read Chapters 1-5 Fall classes begin September 4th more tasks... July 15 deadline for the Application for August Graduation/Completion. My Courses Courses where you are: Student ANT221-0860: Intro to Folklore (Fall 2017) BUA 101 (Fall 2017) Thurs 5pm BUA201-0001: Prin of Financial Acct (Spring 2018) BUA202-0002: Prin of Managerial Acct (Fall 2018) BUA220-0003: Legal Environment of Bus (Fall 2018) BUA235 (COMBINED): Info Systems & Tech for Bus (Spring 2018) BUA325-0001: Prin of Mgt & Organization (Fall 2018) BUA327-0001: Business and Society (Spring 2019) BUA490-0990: Spec Topics Business Admin (Summer 2019) Announcements: Project 1 (FORNITE) due TODAY (by 11.59PM) WEEK 3- Day 3 (My interview with Mike Arcata, General Manager of Philadelphia Phoenix) > WEEK 3: SPORT EVENT MANAGEMENT ECO121-0001: Principles of Macroeconomics (Fall 2017) ECO190-WINT: World Food Supply, Pop & Envir (Winter Session 2018/2019) ECO254 [0400/0990]: Small Business Econ & Managmnt (Summer 2019) ENG317-0991: Business & Technical Writing (Summer 2019) Announcements C SCHOOL OF ECONOMICS ECO254 [0400/0990]: Small Business Econ & Managmnt (Summer 2019) ECO254 SMALL BUSINESS ECONOMICS AND MANAGEMENT Course Material Travis Blackmer Announcements START HERE Course COURSE CALENDAR Announcements Assignments ECO 254 1 WEEK EXTENSION COURSE CONTENT Posted on: Saturday, June 29, 2019 9:23:29 AM EDT Posted by: Travis Blackmer Posted to: ECO254 [0400/0990]: Small Business Econ & Managmnt (Summer 2019) Discussion Board Class, Resources In honor of this Sunday being my birthday...and the amount of emails I've gotten about busy schedules and late work...l have decided to ADD ONE WEEK TO THE ECO 254 COURSE THIS SUMMER. My Grades The YELLOW WEEK is this week. I will extend the EXCEL HOMEWORK 2 that was due last Sunday to this Sunday (if you got a late penalty just email me and I'll take it away) and this will give you an EXTRA WEEK to submit your mid-project updates. Help & Support Support Contacts You are more than welcome to WORK AHEAD, RELAX DURING THE WEEK OF THE 4th, OR CATCH UP! Your call. Blackboard Help Have a great weekend and 4th of July, Travis Blackmer ECO 254 Instructor Week Weekly Lecture Topics Excel Tutorials Excel Homework Exams & Project Syllabus Quiz Due Date (week end on) 1 19-May 2 26-May 3 2-Jun 4 9-Jun 5 16-Jun 6 23-Jun Syllabus, Ch 1 Ch 2 Ch 3 Ch 4 Ch 11 Ch 12 Intro to Excel Excel Tools Intro to Functions Advanced Functions Data and Graphs Excel Project Tutorial HEAD IGNORE uounaall Small Business Reports Discussions D1 D 2, SBR 1 D3 D4 D 11, SBR 2 D 12 Excel Hwk 1 Exam 1, Project DB Post Project Outline Excel Hwk2
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here is the excel

Amortization is the process of paying off debt in fixed timely (annual, monthly, quarterly, etc) payments. The
table below is one tool to determine how much it will take to pay off a certain debt at a given interest rate over a
certain number of years. Take for instance the first row for a one year loan at an interest rate of 7%. At the end of
the year you would pay back 107% of the amount you borrowed if your interest rate was 7%. If you had a 6% loan
that you paid off over 10 years you'd have annual payments of 13.59% of the principle for 10 years. This would
mean that over the life of the loan you'd pay 135.9% of what you borrowed. That additional 35.9% can be
considered the cost of borrowing money. The table graphic below is a standard table that can be used. To the
right there is an additional table. On the coming tabs you can also use an excel function. This will make it easier to
determine payments that are monthly.
Note that when you do monthly payments you need to divide annual interest rates by 12 and
multiply the number of periods by 12 to covert years to months

c) payments. The
en interest rate over a
te of 7%. At the end of
%. If you had a 6% loan
0 years. This would
l 35.9% can be
an be used. To the
s will make it easier to

Rate
# of Periods
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
35
40
45
50
100

1,0%
1,010
0,508
0,340
0,256
0,206
0,173
0,149
0,131
0,117
0,106
0,096
0,089
0,082
0,077
0,072
0,068
0,064
0,061
0,058
0,055
0,053
0,051
0,049
0,047
0,045
0,044
0,042
0,041
0,040
0,039
0,034
0,030
0,028
0,026
0,016

1,5%
1,015
0,511
0,343
0,259
0,209
0,176
0,152
0,134
0,120
0,108
0,099
0,092
0,085
0,080
0,075
0,071
0,067
0,064
0,061
0,058
0,056
0,054
0,052
0,050
0,048
0,047
0,045
0,044
0,043
0,042
0,037
0,033
0,031
0,029
0,019

2,0%
1,020
0,515
0,347
0,263
0,212
0,179
0,155
0,137
0,123
0,111
0,102
0,095
0,088
0,083
0,078
0,074
0,070
0,067
0,064
0,061
0,059
0,057
0,055
0,053
0,051
0,050
0,048
0,047
0,046
0,045
0,040
0,037
0,034
0,032
0,023

2,5%
1,025
0,519
0,350
0,266
0,215
0,182
0,157
0,139
0,125
0,114
0,105
0,097
0,091
0,086
0,081
0,077
0,073
0,070
0,067
0,064
0,062
0,060
0,058
0,056
0,054
0,053
0,051
0,050
0,049
0,048
0,043
0,040
0...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
Related Tags