Loading
Home › Finance Help › I need help with excel homework.
Status: Completed
 View Work

I need help with excel homework.

Date Posted: 05/05/2020
Category: Finance
Due Date: 08/05/2020
Instruction
See Attached: Please Note: For all the homework problems I need to see your calculations or the excel formulas. Providing only the answer will receive zero grade.
Attached
Download File 1 (docx)
Download File 2 (pdf)
Tutor Uploads
Download File 1 (xlsx)
Download File 2 (xlsx)
Download File 3 (xlsx)
Download File 4 (xlsx)
Download File 5 (xlsx)
Bidders
exclusivewriter 6 years, 4 months ago
Rated 9.41 earned 74860.53 around 2443 assignments.
Hey dear, I have checked this project and I can deliver. Please assign me.
$65.00
  • Thanks
    exclusivewriter | May 05, 2020, 17:40 PM
  • So I hope your good at excel.
    User_21887 | May 05, 2020, 21:54 PM
  • How good are you in excel?
    User_21887 | May 06, 2020, 17:22 PM
  • yes sure
    exclusivewriter | May 06, 2020, 17:23 PM
  • I need the first two by Friday. (chapter 3 & 4)
    User_21887 | May 06, 2020, 17:24 PM
  • okay
    exclusivewriter | May 06, 2020, 17:31 PM
  • how is the assignment going?
    User_21887 | May 07, 2020, 17:17 PM
  • I will be done tomorrow
    exclusivewriter | May 07, 2020, 17:18 PM
  • Great, just checking in.
    User_21887 | May 07, 2020, 17:23 PM
  • I have uploaded the first two
    exclusivewriter | May 08, 2020, 15:30 PM
  • what was the formula for both assignmnets.
    User_21887 | May 08, 2020, 21:24 PM
  • Hi Friend could ypou share the formula for the assignmnets
    User_21887 | May 08, 2020, 22:43 PM
  • Formulae are in every cell. Click cell and formular appears at the top
    exclusivewriter | May 08, 2020, 22:44 PM
  • okay thank you
    User_21887 | May 08, 2020, 22:56 PM
  • Per instructions, (2nd one) you are supposed to do the Mini case on pg 189 (on the bottom) you did. I need you to do the correct assignment.
    User_21887 | May 08, 2020, 23:53 PM
  • The first one is perfect.
    User_21887 | May 08, 2020, 23:54 PM
  • Can you have this tomorrow morning?
    User_21887 | May 08, 2020, 23:55 PM
  • Mini Case Page 189-191 Assume that you are nearing graduation and have applied for a job with a local bank. The bank’s evaluation process requires you to take an examination that covers several financial analysis techniques. The first section of the test addresses discounted cash flow analysis. See how you would do by answering the following questions. a. Draw time lines for: (1) a $100 lump sum cash flow at the end of Year 2, (2) an ordinary annuity of $100 per year for 3 years, and (3) an uneven cash flow stream of −$50, $100, $75, and $50 at the end of Years 0 through 3. b. (1) What’s the future value of an initial $100 after 3 years if it is invested in an account paying 10% annual interest? (2) What’s the present value of $100 to be received in 3 years if the appropriate interest rate is 10%?
    User_21887 | May 09, 2020, 00:16 AM
  • It won't let me add it all, but look in the text 189 (bottom of the page)-19. The mini case bottom of the page.
    User_21887 | May 09, 2020, 00:17 AM
  • Good moring, you did the wrong assignment on page 189. It was suppose to the mini case. I need to to repomd.
    User_21887 | May 09, 2020, 16:00 PM
  • Hello, let me check once more
    exclusivewriter | May 09, 2020, 16:03 PM
  • It's the mini case at the bottom of the page. Chapter Problems 3 Problem 3-14 Page 131 4 Mini Case Page 189
    User_21887 | May 09, 2020, 16:06 PM
  • CAn you do this in the next 6-8 hours, because I have to turn it in today?
    User_21887 | May 09, 2020, 16:11 PM
  • Hey, Okay I will try to fix it ASAP. There was some confusion on both the spreadsheet problems and mini case
    exclusivewriter | May 09, 2020, 16:15 PM
  • Okay. I never looked at the text for the assignmnet until one of my classmates asked for help.
    User_21887 | May 09, 2020, 16:22 PM
  • okay
    exclusivewriter | May 09, 2020, 16:22 PM
  • I was wondering, can I send this work by tomorrow morning? Its a lot of work needed for analysis. 6-8 hours is too short for this
    exclusivewriter | May 09, 2020, 17:13 PM
  • It has to be turned in today by 10 pm. Which is about 8 hours. I think if you concentrate on it you can get it done.
    User_21887 | May 09, 2020, 17:18 PM
  • Do u you think you can do it?
    User_21887 | May 09, 2020, 17:55 PM
  • Doing my level best to have it done
    exclusivewriter | May 09, 2020, 17:56 PM
  • okay
    User_21887 | May 09, 2020, 18:34 PM
  • just checking to see how its going on the assignment. It's 7:13 here in ny.
    User_21887 | May 09, 2020, 23:14 PM
  • I’m still pressing on here. Hopefully I will be done by the 11pm
    exclusivewriter | May 10, 2020, 01:06 AM
  • Okay, thanks.
    User_21887 | May 10, 2020, 01:36 AM
  • Attached
    exclusivewriter | May 10, 2020, 02:53 AM

  • User_21887 | May 10, 2020, 03:01 AM
  • g. What is the present value of the following uneven cash flow stream? The appropriate interest rate is 10%, compounded annually. 01234 0 100 300 300 –50 h. (1) Define the stated (quoted) or nominal rate INOM as well as the periodic rate IPER. (2) Will the future value be larger or smaller if we compound an initial amount more often than annually—for example, every 6 months, or semiannually—holding the stated interest rate constant? Why? (3) What is the future value of $100 after 5 years under 12% annual compounding? Semiannual compounding? Quarterly compounding? Monthly compounding? Daily compounding? (4) What is the effective annual rate (EAR or EFF%)? What is the EFF % for a nominal rate of 12%, compounded semiannually? Compounded quarterly? Compounded monthly? Compounded daily?
    User_21887 | May 10, 2020, 03:14 AM
  • i. Will the effective annual rate ever be equal to the nominal (quoted) rate? j. (1) Construct an amortization schedule for a $1,000, 10% annual rate loan with three equal installments. (2) During Year 2, what is the annual interest expense for the borrower, and what is the annual interest income for the lender? k. Suppose that on January 1 you deposit $100 in an account that pays a nominal (or quoted) interest rate of 11.33463%, with interest added (compounded) daily. How much will you have in your account on October 1, or 9 months later?
    User_21887 | May 10, 2020, 03:15 AM
  • l. (1) What is the value at the end of Year 3 of the following cash flow stream if the quoted interest rate is 10%, compounded semiannually? 100 100 100 0123 Y e a r s (2) What is the PV of the same stream? (3) Is the stream an annuity? (4) An important rule is that you should never show a nominal rate on a timeline or use it in calculations unless what condition holds? (Hint: Think of annual compounding, when INOM EFF% IPER.) What would be wrong with your answers to parts (1) and (2) if you used the nominal rate of 10% rather than the periodic rate, INOM 2 10% 2 5%?
    User_21887 | May 10, 2020, 03:17 AM
  • answers to parts (1) and (2) if you used the nominal rate of 10% rather than the periodic rate, INOM 2 10% 2 5%? m. Suppose someone offered to sell you a note calling for the payment of $1,000 in 15 months. They offer to sell it to you for $850.You have $850 in a bank time deposit that pays a 6.76649% nominal rate with daily compounding, which is a 7% effective annual interest rate, and you plan to leave the money in the bank unless you buy the note. The note is not risky—you are sure it will be paid on schedule. Should you buy the note? Check the decision in three ways: (1) by comparing your future value if you buy the note versus leaving your money in the bank; (2) by comparing the PV of the note with your current bank account; and (3) by comparing the EFF% on the note with that of the bank account.
    User_21887 | May 10, 2020, 03:17 AM
  • The mini case study is on page 189-191 a-m You have a-f Completed, when can you give me the rest. I this asap. It's not my fault you did the wrong assignment. Cause as of now I have only half of the assignment and when I turn in late I get docked 50% per day.
    User_21887 | May 10, 2020, 03:20 AM
  • So after all of these hours my professor emailed me back saying that I could send it in tomorrow and get full credit for it. So If you can finish g-m that would be great. I am going to go through the others to make sure we don't have this problem again.
    User_21887 | May 10, 2020, 03:37 AM
  • Okay I will fix it and send your way in the morning
    exclusivewriter | May 10, 2020, 04:57 AM
  • Revised and uploaded please find the attached
    exclusivewriter | May 10, 2020, 10:18 AM
  • It’s suppose to be A- M
    User_21887 | May 10, 2020, 16:31 PM
  • When can you finish. I told you yesterday that it’s page 189-191 A-M. Please finish the whole assignment please. I need this today
    User_21887 | May 10, 2020, 16:33 PM
  • I thought I did this. Did you check the 3rd excel document?
    exclusivewriter | May 10, 2020, 16:39 PM
  • I see it now.
    User_21887 | May 10, 2020, 18:26 PM
  • So for the next 2 assignments: Chapter 5-Problem 5-22 Page 235 Chapter 9 Mini CAse Study p.411-412
    User_21887 | May 10, 2020, 18:37 PM
  • I am trying to fix I(4)The answer is not right EAR at semiannual compounding rate=(1+APR/2)^2-1 =(1+12%/2)^2-1 =12.36% EAR at quarterly compounding rate=(1+APR/4)^4-1 =(1+12%/4)^4-1 =12.55% EAR at monthly compounding rate=(1+APR/12)^12-1 =(1+12%/12)^12-1 =12.68% EAR at daily compounding rate=(1+APR/365)^365-1 =(1+12%/365)^365-1 =12.75%
    User_21887 | May 11, 2020, 02:38 AM
  • Can you help me. So I can turn it in
    User_21887 | May 11, 2020, 02:38 AM
  • So from now own the instructor wants to see the excel formula and also wants to see all of your calculations. Since there are a lot of the students are not getting it. So let's get started early so we don't have the issues that we did last week. Here are the assignments this week. So for the next 2 assignments: Chapter 5-Problem 5-22 Page 235 Chapter 9 Mini Case Study p.411-412
    User_21887 | May 11, 2020, 04:56 AM
  • I will finish this work but its underpaid. Too much work than I expected. All the formulas are in excel cells. Check carefully
    exclusivewriter | May 11, 2020, 04:59 AM
  • I will bonus you at the end. I actually had no idea how much work is involved. The teacher wants us to how calculations in word doc or handwritten. One of your was wrong. i figured out the answer but didn’t know how to change the formula in excel.
    User_21887 | May 11, 2020, 05:19 AM
  • Okay. But please add up bonus to make this project $100. Its too much work for the mini case studies. I had checked all answers and made sure they were all correct, maybe an error occurred while doing it
    exclusivewriter | May 11, 2020, 05:41 AM
  • Chapter 5 5-22 Page 235. Chapter 9 Mini Case Page 411. Working on his
    exclusivewriter | May 11, 2020, 05:41 AM
  • Attached! Excel 4
    exclusivewriter | May 11, 2020, 16:22 PM
  • Thank you. I have another accounting class next semester. But it's just a basic class.
    User_21887 | May 11, 2020, 19:51 PM
  • Okay, I will see you then. Please remember to bonus me up to 100
    exclusivewriter | May 11, 2020, 20:06 PM
  • Okay, off course.
    User_21887 | May 12, 2020, 00:25 AM
  • Just let me know if you need anything.
    User_21887 | May 12, 2020, 00:25 AM
  • Hello, I finished working on all. The last on is attached. Please review, add the bonus and clear the funds
    exclusivewriter | May 12, 2020, 15:46 PM
  • Hllo
    exclusivewriter | May 13, 2020, 06:02 AM
  • I just seen this today. I am looking over everything now.
    User_21887 | May 14, 2020, 17:17 PM
  • No problem. I did great job for you. Please bonus me up and release the funds. If anything let me know
    exclusivewriter | May 14, 2020, 17:21 PM
  • just wait until i have checked all of you answers.
    User_21887 | May 15, 2020, 00:38 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
tutor4U_d_971 6 years, 4 months ago
Rated 9.33 earned 53632.21 around 1383 assignments.
Get professional and exceptional academic services in SPSS, R, Excel, R-Markdown, StatCrunch, PhStat, Tableau, MATLAB, and Ms Project, Sociology, Religion, Political science, Psychology, Health Care, Nursing, Finance and Accounting, Economics, Business, Biology, HRM history and Government, Law, Auditing, Research papers, peer review articles, PPT slides, Calculus, Algebra online classes, and term papers. I guarantee distinct and excellent work. Quality, Timely and 100% plagiarism free work. Nothing short of A+++ and GPA 4.0
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
phoniextutor 6 years, 4 months ago
Rated 8.98 earned 50856.21 around 1767 assignments.
Hello my friend, kindly offer me this gracious opportunity to assist you. Pleasure.
$80.00
  • Hello my friend, kindly offer me this gracious opportunity to assist you. Pleasure.
    phoniextutor | May 05, 2020, 17:25 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
wittywriter 6 years, 4 months ago
Rated 9.07 earned 30263.46 around 985 assignments.
I believe in helping with the homework to the best of my efforts with sincerity. I provide well-analyzed and interpreted work that guarantees GRADE A++. Delivering the homework on time is my utmost priority and being attentive to details by following the instructions carefully. Finance is my profession and so I am well versed with the subject.
$80.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
highquality 6 years, 4 months ago
Rated 8.77 earned 11734.44 around 327 assignments.
Dear client, I have read and understood the task requirements and I can assure you that I will deliver a WELL-RESEARCHED and a HIGH QUALITY paper BEFORE the deadline. In addition, I promise to deliver a 100% plagiarism free paper that meets all your expectations. Kindly assent to my bid. Thank you
$100.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
Vinniax 6 years, 4 months ago
Rated 9.34 earned 13276.58 around 356 assignments.
I am a guru in excel and I will give you an A in the work. Please look at my profile and choose me
$100.00
  • I hold an MSC in Financial Mathematics so I am better positioned than no one else to handle this work.
    Vinniax | May 05, 2020, 17:24 PM
  • I am looking forward to working with you.
    Vinniax | May 05, 2020, 17:25 PM
  • I am still waiting for you.
    Vinniax | May 05, 2020, 17:29 PM
  • Hello there
    Vinniax | May 05, 2020, 17:39 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}
 
 
lupita 6 years, 4 months ago
Rated 9.36 earned 11670.86 around 435 assignments.
Hey, allow me to assist you with your assignment. Am an expert and only deliver quality and plagiarism free work within the stipulated time. I have the ability and experience to work on every possible niche. Accord me the chance to help you. Thank you
$35.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[6] $}

{$ showNewChatSuccessMsg[6] $}
Unable to send Message: {$ showChatProcessErrorMsg[6] $}
 
 
queen 6 years, 4 months ago
Rated 9.56 earned 68909.63 around 2359 assignments.
Hello friend, I have background training in this subject and I promise to commit my great experience to guarantee you a top class and excellent work, 100% free from PLAGIARISM, and within the stipulated time frame. Please trust me with your assignment. Thank you in advance.
$200.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[7] $}

{$ showNewChatSuccessMsg[7] $}
Unable to send Message: {$ showChatProcessErrorMsg[7] $}
 
 
COMMITEDTUTOR 6 years, 4 months ago
Rated 9.18 earned 5387.52 around 193 assignments.
Hi, I have significant experience with various kinds of papers. I’m really interested in your assignment and I would like to have the chance to work on this task. I hope you can send me additional details for this. Contact me ASAP so we can discuss more about this.
$75.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[8] $}

{$ showNewChatSuccessMsg[8] $}
Unable to send Message: {$ showChatProcessErrorMsg[8] $}
 
 
aggrey 6 years, 4 months ago
Rated 9.47 earned 33434.92 around 816 assignments.
I am a proficient and professional writer. I am diligent in my work, timely and always provide papers of the highest quality. Assign me your order and be sure of a flawless and plagiarism free paper.Thank you
$50.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[9] $}

{$ showNewChatSuccessMsg[9] $}
Unable to send Message: {$ showChatProcessErrorMsg[9] $}
 
 
surrogatewriter 6 years, 4 months ago
Rated 9.31 earned 75264.37 around 2854 assignments.
Hey dear, I have checked this project and I can deliver. Please assign me.
$65.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[10] $}

{$ showNewChatSuccessMsg[10] $}
Unable to send Message: {$ showChatProcessErrorMsg[10] $}
 
 
DoctorAssignment 6 years, 4 months ago
Rated 8.94 earned 2734.77 around 97 assignments.
Hey dear, I have checked this project and I can deliver. Please assign me.
$65.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[11] $}

{$ showNewChatSuccessMsg[11] $}
Unable to send Message: {$ showChatProcessErrorMsg[11] $}
 
 
SolutionASAP 6 years, 4 months ago
Rated 8.96 earned 13184.04 around 380 assignments.
I am one of the leading Expert in this subject over here can do well very minimal time frame with accurate solutions. PS: Results are accurate,
$35.00
  • Are you good in excel?
    User_21887 | May 05, 2020, 17:34 PM
  • Hire me. I can do very best for you. Let me check and start working on it.
    SolutionASAP | May 05, 2020, 17:37 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[12] $}

{$ showNewChatSuccessMsg[12] $}
Unable to send Message: {$ showChatProcessErrorMsg[12] $}