Calculation in Excel, when is the investment profitable

Markus Freitag 3,791 Reputation points
2023-04-09T16:28:31.8966667+00:00

TEST_2_Calc_.XML.TXT Hello, interest rates on call money and savings bonds are now available again. The question is wait or invest.

  • Call money 0,6%
  • Savings bond 2,0%

In 6 months it may be 3%. Therefore the question, can I represent in Excel that, when it is worthwhile to invest now already 2%, if also immediately in the autumn it gives 3%. The bottom line is that waiting may not be so good. Similar to the break even analysis. Thanks for tips. Greetings Markus Anlage_Beispiel

Rename the file from txt to xml, load it into Excel.

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <AllowPNG/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>8970</WindowHeight>
  <WindowWidth>24885</WindowWidth>
  <WindowTopX>0</WindowTopX>
  <WindowTopY>0</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Tabelle1">
  <Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="10" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="60" ss:DefaultRowHeight="15">
   <Row ss:Index="5">
    <Cell ss:Index="3"><Data ss:Type="Number">2</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="2"><Data ss:Type="Number">10000</Data></Cell>
    <Cell ss:Formula="=RC[-1]*R[-1]C%"><Data ss:Type="Number">200</Data></Cell>
   </Row>
   <Row ss:Index="9">
    <Cell ss:Index="3"><Data ss:Type="Number">0.6</Data></Cell>
    <Cell><Data ss:Type="Number">0.9</Data></Cell>
    <Cell><Data ss:Type="Number">1.2</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
   <Row>
    <Cell ss:Index="2"><Data ss:Type="Number">10000</Data></Cell>
    <Cell ss:Formula="=R10C2*R[-1]C%/4"><Data ss:Type="Number">15</Data></Cell>
    <Cell ss:Formula="=R10C2*R[-1]C%/4"><Data ss:Type="Number">22.500000000000004</Data></Cell>
    <Cell ss:Formula="=R10C2*R[-1]C%/4"><Data ss:Type="Number">30</Data></Cell>
    <Cell ss:Formula="=R10C2*R[-1]C%/4"><Data ss:Type="Number">100</Data></Cell>
    <Cell ss:Formula="=SUM(RC[-4]:RC[-1])"><Data ss:Type="Number">167.5</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.3"/>
    <Footer x:Margin="0.3"/>
    <PageMargins x:Bottom="0.78740157499999996" x:Left="0.7" x:Right="0.7"
     x:Top="0.78740157499999996"/>
   </PageSetup>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>10</ActiveRow>
     <ActiveCol>6</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more