Create Google sheet + Microsoft Excel calculation for interest

Cerrado Publicado hace 9 meses Pagado a la entrega
Cerrado 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.

Excel Entrada de datos Procesamiento de datos Google Sheets WordPress

Nº del proyecto: #37009291

Sobre el proyecto

52 propuestas Proyecto remoto Activo hace 8 meses

52 freelancers están ofertando un promedio de $29 por este trabajo

schoudhary1553

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

$80 USD en 2 días
(586 comentarios)
8.5
rohitagarberg

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

$50 USD en 1 día
(522 comentarios)
6.9
nimiwebjuggler

Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.

$10 USD en 1 día
(152 comentarios)
6.6
digilogiks

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

$10 USD en 1 día
(34 comentarios)
5.5
merinsinha

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

$30 USD en 1 día
(168 comentarios)
5.8
freelancerabdu34

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

$30 USD en 1 día
(60 comentarios)
5.2
mhgroup21

Dear Client, I have sound knowledge of excel and analytics. Also, I previously carried out several projects in excel using pivot and macro. I ensure you will be happy after hiring me. Kindly contact me. Check my port Más

$50 USD en 1 día
(41 comentarios)
5.0
AnuradhaVM

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

$20 USD en 2 días
(42 comentarios)
4.8
MahmoudRafatAli

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

$30 USD en 1 día
(37 comentarios)
4.1
smkssmart1

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

$20 USD en 7 días
(1 comentario)
3.5
sdiego2020

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

$20 USD en 1 día
(6 comentarios)
3.1
kavitadhingra

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

$20 USD en 7 días
(7 comentarios)
2.8
Awais0507

My name is Muhammad and I am excited to help you create the Google sheet + Microsoft Excel calculation for interest. With over experience in Data Entry, Data Processing, Excel and related software technologies, I am co Más

$20 USD en 1 día
(2 comentarios)
2.0
ahmedsud

Good morning! I understand that you need help with creating a Google sheet + Microsoft Excel calculation related to interest rates for loans. I have extensive experience and the skills necessary to complete this projec Más

$20 USD en 3 días
(2 comentarios)
1.7
THgolden

( ͡❛ ᴗ ͡❛ )Hi, Hans A.✔️ I read your suggestion carefully. I've gone through the job posting. It seems that you're looking for a coder who have rich experiences on Data Entry, Excel, Data Processing, Google Sheets an Más

$20 USD en 1 día
(0 comentarios)
0.0
solomiiahuliak

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

$50 USD en 3 días
(0 comentarios)
0.0
nazar33d

Hi, Hans A. I've gone through the job posting. It seems that you're looking for a coder who have rich experiences on Data Processing, Data Entry, Excel, Google Sheets and WordPress. I've worked with another client i Más

$20 USD en 1 día
(0 comentarios)
0.0
myramij

Greetings, Simple math equation for me. As a payroll manager in my previous work experinces, I can do this easily. Thanks.

$30 USD en 3 días
(0 comentarios)
0.0
mahafuz90

Hello Sir, I read your project and I can do Google sheet + Microsoft Excel calculations for interest work perfectly without errors. I will do Supreme Quality Work at a very low price. So I want one chance to prove myse Más

$12 USD en 2 días
(0 comentarios)
0.0
AbdullahArab01

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

$20 USD en 7 días
(0 comentarios)
0.0