Create Google sheet + Microsoft Excel calculation for interest
$10-30 USD
Pagado a la entrega
I need help with a sheet + excel calculation related to loans for build a house.
Background:
Different banks offers different interest and i want to be able to fill in a sheet that show me the total costs compared differtent banks in one Google Sheet and also one Excel.
The sheet needs:
Field 1: Total cost of the house
Field 2A: Name of bank A Field 2B: Interest offered from bank A
Field 3A: Name of bank B Field 3B: Interest offered from bank B
Field 4B: Name of bank C Field 4B: Interest offered from bank C
Field 5A: Name of bank D Field 5B: Interest offered from bank D
Field 6: Calendar - The calendar is used to fill in the payments.- Here i want a Monthly calender from 1 of august 2023 that stops at 31 december 2025. Every date should have two cells, one for SEK (Swedish Krona) and one in %.
If I know the amount I will pay i use the cell for SEK. If I only now the price in % of the total amount I use the cell for %.
For example payment X is 200 000 SEK should be paid 2023-08-10 I fill in the amount of the invoice in the SEK cell. If I only knows that i will get an invoice of 20% of the total cost of the house i use the cell for %.
At the bottom of every month there should be a copy of the banks name that is filled in 2A - 2D and the SUM of the total cost of the interest for the month. There should also be a separate SUM of the total cost so it can be compared between the different banks. The total SUM of the costs are not allowed to be more that Field 1.
The calculation should be able to use on a wordpress website.
Nº del proyecto: #37009291
Sobre el proyecto
52 freelancers están ofertando un promedio de $29 por este trabajo
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Más
Hi there..i am an expert in excel and Google sheet..will create the financial sheet of loan requirement for you...looking forward to work with you..thanks
Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.
I understand that you need help with a sheet + excel calculation related to loans for build a house. Specifically, I would like to discuss how I can help you with your project. I believe I am the perfect fit for this Más
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform Más
Greetings, I am an Advanced Level Google Sheets & Excel expert and an Accountant. I am very confident to start your project and complete it with all efficiency you are looking for. I understand the requirements and am Más
Hello, I have data entry expertise and excellent skills in Power BI, Excel, and Google Sheets. This enables me to solve any related problems, including VBA programming efficiently. Collaborating with me will provide g Más
Hello, my name is Mahmoud and I am a support professional with top quality service. I understand that you are looking for help with creating a Google sheet + Microsoft Excel calculation related to loans for build a hou Más
Good Day, With over 15 years of experience in data processing, Excel, and Google Sheets, I can certainly help you create a comprehensive tool for comparing loans to build a house across different banks. Your project a Más
Hi there, I'm a qualified engineer with expertise in data processing, analysis and management in different formats (including Advanced Excel / Macros / VBA / Google sheets / MS Office) - I´m well organized and detail o Más
Hello! I am Kavita and I am a professional with 15 years of industry experience in various technologies like Power BI, SQL Server, Excel, VBA, SQL Server, MS Office and SSIS. I have worked on multiple Power BI projects Más
Hello Hans A. Good evening! I am excited to submit my proposal for the "Create Google sheet + Microsoft Excel calculation for interest" position. I have developed a strong set of skills that make me confident in my abi Más
Greetings, Simple math equation for me. As a payroll manager in my previous work experinces, I can do this easily. Thanks.
Hi Dear, I propose creating a dynamic Google Sheet and Excel workbook to compare loan options for building your house. The sheet will include fields for bank names, interest rates, and a monthly calendar from Aug 202 Más