I need an Excel Expert
$30-250 USD
Paguhet në dorëzim
Excel Case 1 (Mortgage Amortization)
Given the following information:
Interest Rate (yearly): 3.5%
Mortgage: $250,000
Term (in months): 360
Start Date: October 1, 2019
Yearly Bonus: $10,000
Formulas to incorporate:
PMT
EDATE
SUM
Other Notes:
Do amortization monthly.
For each scenario, graph the interest paid and principal paid for each month on a line chart together for all months that the loan is active. Create a second line chart that graphs the cumulative interest paid and cumulative principal paid by month. Make sure to include the dates on the x-axis and title your charts.
Format using headers, currency with two decimals and any other formatting to make your spreadsheet look professional.
Note that the interest rate is yearly and that your amortization table is monthly.
Anchoring cells will make it faster to develop your spreadsheet.
You’ll want to set up your spreadsheet to have the following columns: Starting Balance, Interest Accrued, Payment, Principal, Ending Balance, Cumulative Interest, Cumulative Principal.
Case:
What is the minimum payment each month?
Scenarios (complete each scenario on a separate tab and label each tab appropriately):
1. Pay the minimum required.
2. Pay an extra $250/month. When will you have the loan paid off by?
3. Pay an extra $250/month and make a larger payment (equal to 50% of your year end bonus) each December. When will you have the loan paid off by?
ID Projekti: #22649412
Rreth projektit
Është zgjedhur fitues:
That is a simple and straightforward job as per my standards. I am a professional Financial Analyst holding years of experience in aspects of Finance. I will be happy to discuss in detail how I am highly suitable for t Më shumë
31 profesionistë freelancer dërguan një ofertë mesatare prej $120 për këtë punë
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss. Thanks, Asad Khan FixIT Consultancy
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Thank you, Regards.
$ 60 Only ---- In just 12 Hours ----- Excel VBA Macro Coding, Formula Generation and Automation Expert with 5* rattings.
Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. Also, being a primarily commerce student I am aware of the specific calcul Më shumë
Hello, I can help with your accounting task using excel. Send me a message and let's discuss this further. Thanks.
I can develop excel based mortgage amortization with dynamic dashboard to present key results, scenario analysis and sensitivity analysis. Lets discuss this in detail in chat or over a call. Please find below a brief Më shumë
Hello Dear, I do have the relevant skills you can see my profile. i can Provide you up to the mark Services. Thanks & Regards Muhammad Ilyas Saeed
Hy, I have read the project details provided in the requirements and can work on your project. I have already completed more than 250 academic papers, articles, and technical articles. I can provide you samples. I be Më shumë
Hi there, I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in excel report design, but can do most tasks needed in excel. I have a solid understanding of accounting Më shumë
Hi, I am Sumit Choudhary. I saw your requirement for an excel expert. I have done many projects in excel. Can send you sample if needed. I have an MBA and have extensive experience in tutoring students in Economics, Më shumë
Dear sir, I am an data entry operator from last one year. I request you to give me this proje7ct, so that I can full fill your need. Relevant Skills and Experience I am an data entry operator. From last one year.
dsefccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccrrrrrrrrrrrrrrrrrrrrrr
Good evening, I would very much like to work with you on this project and request that you contact me through www.Freelancer.com to discuss specifics. Thank you in advance. Best Regards, Julia Neviera
I am Microsoft Certified Professional and a Microsoft Office Specialist with over 25 years working with Excel.
Hi sir, I have read the project details provided in the requirements and can work on your project. I have already completed more than 250 academic papers, articles, and technical articles.I believe my capabilities woul Më shumë
Dear Hiring Manager, Hope you are fine and happy with your life. Before I start my letter I want to thank you for posting the job. In your job posting you are looking for a Data entry expert who knows every basic of da Më shumë
i experienced in advance excel work like vlookup , Hlookup, pie chart ,vba any types of excel work etc and accounting work data entry etc
